find vals which are in one table but not in another

[scriptKiddie]

i have 2 tables I need to find values which are present in t1 but not present in t2.
P.S. Using MS access

thanx in advance

[russell]

SELECT t1.field
FROM t1
LEFT JOIN
t2
On t1.someField = t2.someField
WHERE t2.field is NULL

[scriptKiddie]

thanx it worked