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

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.