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?

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

Follow this topic