What is the difference between ON and WHERE?

Answer 1

I understand your concern. Fortunately, it is quite simple...

WHERE is a part of the SELECT query as a whole, ON is a part of each individual join.

ON can only refer to the fields of previously used tables.

Dr.

Answer 2

Hi Dr.,
so if I understand well, ON can only be used on previously selected tables but that does not imply that WHERE can replace ON in every occasio. Is that correct?