G
Guest
I am trying to join two tables that link on 4 fields. Table one will contain
records with no match to the combined linking fields in table 2, thus I want
all records in table 1 and all matching records from table 2. The output
includes an aggregate (sum) field from both tables. Using LEFT OUTER JOIN to
define each of the four joins hasn't worked.
DM
records with no match to the combined linking fields in table 2, thus I want
all records in table 1 and all matching records from table 2. The output
includes an aggregate (sum) field from both tables. Using LEFT OUTER JOIN to
define each of the four joins hasn't worked.
DM