Last answered:

27 Mar 2023

Posted on:

18 Mar 2023

0

Resolved: s.from_date = s1.from_date position in the query

Why s.from_date = s1.from_date is in WHERE and not in JOIN ON?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

27 Mar 2023

0

Hi Nick!
Thanks for reaching out.


Actually, it does not matter. You can test both queries and they give the same result set.


Hope this helps.
Best,
Tsvetelin

Submit an answer