Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SIMPLE LEFT JOIN QUESTION

Status
Not open for further replies.
Feb 8, 2002
43
US
I am doing a left join between 2 tables.
I know that it will return everything on the left as well as everything that it matches with on the right.

HOWEVER, I want to do a left join that returns everything on the left BUT leave out all the records that match with the right.

How would I do this?
 
Try something like this:

SELECT table1.*
FROM table1 LEFT JOIN Table2 ON table1.DBID = table2.DBID
WHERE (((table2.DBID) Is Null));

Also check the join properties by rightclicking the Join in design view and choose either option 2 or 3.

Bye,
Jeroen

A 3d level editor in Delphi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top