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.. |
||
