Microsoft KB Archive/109563

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

Article ID: 109563

Article Last Modified on 1/8/2003

-

APPLIES TO


 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 16-bit Enterprise Edition
 * Microsoft Visual Basic 3.0 Professional Edition

-



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.

Additional query words: 3.00 4.00 vb416

Keywords: KB109563

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.