Query Search

[Arg81]

Simple Question, although I can't think straight today:

How can I compare 2 tables, and load data from Table1 based on my ID NOT existing in Table2?

I want to do this as a normal dataAdapter if possible, but think I need to call it as a stored procedure.

Basically I want my form to load all parent records that don't have any child records


Regards,
Luke

 

[Arg81]

solved

Finally found a post on here, and adjusted my code as necessary;

select tblRequest.RequestID from tblRequest full join tblRequest_Work on tblRequest.RequestID = tblRequest_Work.RequestID
where tblRequest_Work.RequestID is null

simple!