query

[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

 

[Van T. Dinh]

SELECT T1.*
FROM [tbl1] AS T1 LEFT JOIN [tbl2] AS T2
ON T1.LinkField = T2.LinkField
WHERE T2.LinkField Is Null

 

[Guest]

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

.