What is the difference between ON and WHERE?

27th Dec 2016, 3:19 PM

Nastia Polina

2 Answers

+ 4

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.

27th Dec 2016, 3:41 PM

Tristan McCullen

+ 1

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?

29th Dec 2016, 3:24 PM

Mario Scarpa