Thank you. That's what I wasn't getting. The difference between the ON and the OUTER. I was conflating the two (yes, even while reading the steps as described by chiesa.alberto).

Thanks...

Thanks for this article. It brings to the fore my lack of understanding of the difference between the join and where clauses.

I still don't understand why the clause 'AND Class.ClassYear...

For the poll, let's ignore simple jobs like restaurants, landscapers, etc. There will always be people doing those jobs. Let's instead focus on careers for people. Will they be digital...