query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables

tbl1 has the following record A,B,C,D
tbl2 has the following record B,C

I would like a query to return only the records from tbl1
that are not there i tbl2.

Thanks
 
SELECT T1.*
FROM [tbl1] AS T1 LEFT JOIN [tbl2] AS T2
ON T1.LinkField = T2.LinkField
WHERE T2.LinkField Is Null
 
Thank you Van.
-----Original Message-----
SELECT T1.*
FROM [tbl1] AS T1 LEFT JOIN [tbl2] AS T2
ON T1.LinkField = T2.LinkField
WHERE T2.LinkField Is Null

--
HTH
Van T. Dinh
MVP (Access)




I have 2 tables

tbl1 has the following record A,B,C,D
tbl2 has the following record B,C

I would like a query to return only the records from tbl1
that are not there i tbl2.

Thanks
Click to expand...


.
Click to expand...
 
Back
Top