Resolved: 2nd solution uses AND with JOIN statements, and not with WHERE clause

Question

The second solution option uses "AND m.from_date = t.from_date" right after the last JOIN. I would have used "WHERE m.from_date = t.from_date" The result appears to be the same, but can you explain why simply using AND works without any WHERE?

Answer 1

Hi Adam!
Nice question! It means that you learn with understanding!
When using JOIN(=INNER JOIN) with an ON clause, it is the same as the WHERE clause. This is not true for LEFT/RIGHT joins.

Hope this helps.
Best,
Tsvetelin

Resolved: 2nd solution uses AND with JOIN statements, and not with WHERE clause

Submit an answer

related questions