Introduction to SQL in Salesforce Marketing Cloud: Lesson 3 - JOINs in SQL

[@giovannigalvis1618]

Thanks for the valuable content, I can already feel the SQL flowing through my blood. Thanks again for this tutorial/guide very helpful.

[@paulamegens7406]

Amazing content Cameron, you explained soooo good! Thanks!

[@kellybartolo2846]

Cliff hanger! These videos are so helpful. Thanks for sharing Cameron!

[@antaraghosh6871]

So easy to understand. Thanks for sharing Cam!

[@akshitbansal2966]

Great video as usual. Please keep them coming. Really helpful and much appreciated

[@ManpreetSingh-sl3qi]

Awesome videos..really helpful

[@shivkumar-ge9yy]

🙏🏻

[@JerryPemberton]

I don't understand how the LEFT JOIN is pulling in records from the Customers table when they are not present in the EventReminder table. The CustomerID on both tables need to match, right? Isn't that what the ON clause is looking for? The same exact CustomerID value in *both* tables? If they exist in only one of the tables, how is there an equality match?

[@e73bus]

LEFT JOIN takes all records from the Customers table and only the records in the EventReminder that match the ON clause. What you are describing is rather an INNER JOIN

[@JerryPemberton]

@@e73bus Thank you!