I have to tables that look like this
Table 1
Type Description
A Description A
B Description B
C Description C
Table 2
Type Description
A Description A
B Description B
C Description C
D Description D
E Description E
Is there a way I could compare both tables to identify the differences?
For example, I want to generate a report to show type D and E is not on table 1.
I appreciate any suggestions.
Tim
Table 1
Type Description
A Description A
B Description B
C Description C
Table 2
Type Description
A Description A
B Description B
C Description C
D Description D
E Description E
Is there a way I could compare both tables to identify the differences?
For example, I want to generate a report to show type D and E is not on table 1.
I appreciate any suggestions.
Tim