One of ways you can select those IDs from one table that are not contained in other table is:
select distinct A.ID from A LEFT OUTER JOIN B ON A.ID=B.ID WHERE B.ID is NULL
This select statement will create pair of corresponding rows from both tables, those IDs of table A, that are not contained in table B, will have NULL matching values from table B.
Codes here !
1 post • Page 1 of 1