find vals which are in one table but not in another

[scriptkidd]

i have 2 tables I need to find values which are present in t1 but not present in t2.

thanx in advance

[GolferGuy]

Here is the SQL code for what you want. Of course you will need to change the table and field names to match what you are using.

SELECT T1.Fld1, T1.Fld2, T1.Fld3
FROM T1 
    LEFT JOIN T2 
      ON T1.Fld1= T2.Field1
WHERE (((T2.Field2) Is Null));

Hope this helps,
Vic

[scriptkidd]

thanx it helped