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
