Which records will your query keep? An INNER JOIN returns matching customer-contact pairs. A LEFT JOIN keeps every customer, including the ones with no contact, and supplies Null for the missing contact fields. This companion infographic adds a visual reminder and sample SQL. Watch my Outer Joins video to see the matching-record rules in action in Access Query Design.