SQL JOIN -: what is the difference between WHERE clause vs.and ON clause?

After reading itWhat is the difference and what should go in each?

If I understand the theory correctly, the query optimizer should be able to use both interchangeably.

(Note: this question is not a duplicate of Explicit vs Implicit SQL Joins. The answer may be related (or even the same) but the question is different.

What is the difference and what should go in each?

If I understand the theory correctly, the query optimizer should be able to use both interchangeably.)

Question Protected by Ciro Santilli OurBigBook.com

occurred Dec 3, 2021 at 21:18

edited title

Link

edited Apr 7, 2020 at 19:06

Vlad Mihalcea

155.9k
85
599
984

SQL join: whereJOIN - WHERE clause vs. onON clause

replaced http://stackoverflow.com/ with https://stackoverflow.com/

Source Link

edited May 23, 2017 at 10:31

URL Rewriter Bot

After reading it, this is not a duplicate of Explicit vs Implicit SQL Joins Explicit vs Implicit SQL Joins. The answer may be related (or even the same) but the question is different.

What is the difference and what should go in each?

If I understand the theory correctly, the query optimizer should be able to use both interchangeably.