find missing data

[sameroh]

I have two tables T1 , T2 each have one field Invoice Number in T1 and

Invoice Number in T2 , lets say in each table in each field : T1 : 1,2 and 3

T2 : 1 and 2

So if I want to find records in T1 which is not in T2 what can I do?

 

[KeithG]

Use a left join from T1 to t2 and the use is null in the criteria row of t2.Invoice Number

 

[samer]

Thanks , but how to write sql ..

 

[Banana]

No need to write SQL. You can do it within design view. Put in t1 and t2, then with the linking fields, create a join by clicking and dragging t1 PK to t2 FK. (If you didn't know, join != relationship), then click on #2 (show all records from t1 and only those from t2 where there is a match). Run it.

When you've done that, you can switch to SQL view and look at how it's written.