Thread: How do you compare contents of two tables using 2 pk

How do you compare contents of two tables using 2 pk

From

"Kent Anderson"

Date:

24 February 2005, 20:18:36

I have two tables that should contain the same number or records. Both tables use the same 2 foreign keys as their primary keys.

I did a count on the number of records in both and found one table has 500 records less than the first table so I need to know which records are not in the second table.

table 1

t1_fk_wm (FK)

t1_fk_hm (FK)

...

table 2

t2_fk_wm (FK)

t2_fk_hm (FK)

....

Table 2 doesn't have the same number of records as the first table however it should.

Any suggestions would be appreciated as I am still very much a beginner at SQL.

Kent Anderson

Re: How do you compare contents of two tables using 2 pk

From

"Joel Fradkin"

Date:

24 February 2005, 20:32:15

Couldnt you do a select * from t1 where not in uniquevar (select uniquevar
from t2)?
Or do a join and select on a value in t2 being null.

Joel Fradkin