!full! | Sql Joins Notes Pdf

SELECT * FROM orders o JOIN customers c ON o.customer_city = c.city AND o.customer_zip = c.zip;

Imagine two intersecting circles. LEFT JOIN represents the entire left circle , including the intersection. sql joins notes pdf