Women in Technology

Hear us Roar



Article:
  The Outer Limits of SQL JOINs
Subject:   Missed out.
Date:   2002-11-10 09:05:12
From:   anonymous2
The article was really covering the various possibilities of the outer join except one.
There can be a requirement when the records that are in excess in one of the tables alone should be listed. Is there any method to get the records that are present in Table 1 but not in Table 2.
Note:- This does not pertain to a single column, it should be applicable over a set of columns.
Eg:- Table 1 has cols 1 and 2. Table 2 has cols 1 and 2. Requirement is to list out the records in Table 1 which does not have a matching record for cols 1 and 2 (both taken together together) in Table 2. Thanks..