tgarner444
November 18th, 2008, 06:47 PM
Okay, an equal join gets records with matches in both files. A left outer join gets all records in the primary file and matching records from the lookup file. What join selects those records from the primary file for which there is no matching records in the lookup?
I want active customers (primary file) who did not buy this year (lookup file.)
I want active customers (primary file) who did not buy this year (lookup file.)