- 2

Using where is better than join

I always read that using where is better than join. Why?

21st Jul 2021, 9:32 PM
José Ernesto Carreño Bueno
José Ernesto Carreño Bueno - avatar
6 Réponses
+ 3
Can you share the resources mentioning that claim? I'm interested to read the reasonings.
22nd Jul 2021, 12:36 AM
Ipang
+ 2
Calvin Thomas it is used in SQL to filter results.
22nd Jul 2021, 6:41 AM
Simon Sauter
Simon Sauter - avatar
+ 2
José Ernesto Carreño Bueno Is this about SQL? "WHERE" and "JOIN" serve different purposes. I'm not sure what could make one better or worse than the other. Maybe you can provide more context? Or a source for the claim?
22nd Jul 2021, 6:44 AM
Simon Sauter
Simon Sauter - avatar
+ 1
22nd Jul 2021, 5:12 AM
Calvin Thomas
Calvin Thomas - avatar
0
22nd Jul 2021, 6:43 AM
Calvin Thomas
Calvin Thomas - avatar
0
You can use where table1.id=table2.value to join 2 tables
22nd Jul 2021, 11:28 AM
José Ernesto Carreño Bueno
José Ernesto Carreño Bueno - avatar