• Guessing here, but I think you want a FULL OUTER JOIN on Last Name, First Name and Product Name (QualityType is a possibility too I suppose). You can filter after that if you like for things not equal or missing on either side of the set.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service