How to Use SQL Outer Join to Find All Table B Records Not in A (109563)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition for Windows 3.0
This article was previously published under Q109563
The following SQL query retrieves all of the records from table B in which
there is no matching record in table A:
Select B.* From A,B, B Left Join A On B.Key=A.Key Where A.Key Is Null;
This type of outer join query is the functional opposite of an inner join.
You can use this SQL query to create a Dynaset of records with the
CreateDynaset statement.
| Modification Type: | Minor | Last Reviewed: | 1/8/2003 |
|---|
| Keywords: | KB109563 |
|---|
|