Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing two tables 1

Status
Not open for further replies.

TimothyP

Programmer
Aug 6, 2002
135
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top