Easy SELECT question

[Tonatiuh]

In a Visual FoxPro DB (as BackEnd), I have two tables (T1, T2) with a 'ncontra' field in both tables.

I want to select all 'T1.ncontra' which are not present in 'T2.ncontra'. This is.

If ncontra = XXX exist in T1 but not exist in T2; select it. If ncontra = YYY exist in T1 and also Exist in T2; don't select it.

Of course I was accesing from VB (as a FrontEntd)

Thanks

[JHausmann]

A SQL statement to do what you want would be

select ncontra from t1 where ncontra not in(select distinct ncontra from t2)

[Tonatiuh]

Thanks a lot JHausmann!

Ulises