Compare sequences in two tables to find missing sequence no [message #190210] |
Tue, 29 August 2006 13:21 |
coolguy01
Messages: 64 Registered: August 2006
|
Member |
|
|
hey i have two tables with a similar type of column that conatin some sequence numbers. The second table is actually a table which conatins the missing sequence nos in the first table. Even then there may still be some more nos in the sequence missing..... so how do i compare both the tables to find the missing sequence nos or rows from both the table?? how do i compare the two tables??
|
|
|
|