sql syntax for selecting the records that don't match

[jhall251]

I need to select the records from tableA that do not have a matching record in TableB. I can do that in VFP lingo easily but would like to use SQL. I don't see an easy way to do this with SQL - is there a straightforward way? Thanks for any help...

Joe Halloran

 

[TheRambler]

select * from tableA where keyField not in ;
(select keyField from tableB)

 

[jhall251]

Thanks much - that works.

Joe Halloran

 

[kosta]

Hi ,
additional question by this way how would be full solution for data synchronization with the same structure table between two folder ?

TIA

Soykan OEZCELIK