Recently, I had the opportunity to help with a query that was looking at a CRM and ERP database, trying to compare customers and addresses to try and make them the same.
I've taken that work and created a simple lesson on JOINs and LEFT JOINs
Enjoy