Using where is better than join

Question

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

Answer 1

Can you share the resources mentioning that claim? I'm interested to read the reasonings.

Answer 2

Calvin Thomas it is used in SQL to filter results.

Answer 3

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?

Answer 4

José Ernesto Carreño Bueno What's 'where'?

Answer 5

Simon Sauter I see.

Answer 6

You can use where table1.id=table2.value to join 2 tables