How to Use SQL Outer Join to Find All Table B Records Not in A

ID: Q109563

The information in this article applies to:

Microsoft Visual Basic Professional and Enterprise Editions, 16-bit only, for Windows, version 4.0
Microsoft Visual Basic Professional Edition for Windows, version 3.0

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.

Additional query words: 3.00 4.00 vb416

Keywords :
Version :
Platform :
Issue type :