Subqueries in SQL (Inner Queries, Nested Queries)

[@icebear4325]

Your teachings are better from the courses I enrolled online. Thanks!

[@sdwivedi27]

Could you have returned the same search results using an INNER JOIN on the Customer ID key between the Orders table and Customers table and then applying the where clause to get the desired result for the year? If so, what is the advantage of using the nested query rather than the INNER JOIN?

[@joeschmoe7563]

Yes you can get the same results from using an INNER JOIN and then applying the where clause to get the desired result for the year. As far as the advantages of using one over the other I'm not quite sure.

[@Christopheralb]

@@joeschmoe7563 Yeah I was gunna ask what's the difference between using subqueries vs joining the tables and then filtering from there. It seems like it's just preference if I had to guess.