J
JMorrell
This question has been posted before but I can’t find it.
The onus is on me to merge two training dbases with tables in each that hold
similar information (class name and class date). I can find where the
records are the same, but not where records are not in the other table.
e.g., class abc on 01/05/2004 is listed in both tables, but class abc on
01/10/2004 is not.
I want to build a query that lists all dissimilar classes in each table.
i.e., the class that are in table1 which are not in table2, AND classes in
table2 that are not in table1.
Eventually, I will be merging dissimilar class information from table2 into
table1.
Does anyone have experience with this sort of merge? What's the best way to
go about it?
tia,
The onus is on me to merge two training dbases with tables in each that hold
similar information (class name and class date). I can find where the
records are the same, but not where records are not in the other table.
e.g., class abc on 01/05/2004 is listed in both tables, but class abc on
01/10/2004 is not.
I want to build a query that lists all dissimilar classes in each table.
i.e., the class that are in table1 which are not in table2, AND classes in
table2 that are not in table1.
Eventually, I will be merging dissimilar class information from table2 into
table1.
Does anyone have experience with this sort of merge? What's the best way to
go about it?
tia,