Обсуждение: How do you compare contents of two tables using 2 pk

Поиск
Список
Период
Сортировка

How do you compare contents of two tables using 2 pk

От
"Kent Anderson"
Дата:
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

От
"Joel Fradkin"
Дата:
Couldn’t 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