Comparing two tables 1

[TimothyP]

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

 

[lbass]

Make your larger table the leftmost and then do a left join from that table to the right one, i.e., use a left join from Table2 to Table1. Then create a record selection formula like:

isnull({table1.desc})

This would return all rows in Table2 that had no matching description in Table1.

-LB