I have three tables:

Htc.dbf
NewError.dbf
OldError.dbf

I would like to populate a grid that only lists teh Htc id, name and address that have new errors and old errors that are not listed in teh NewErrors table.

Basically, select htc.id, name, address where htc id matches the news errors table and htc id matches with the old errors table but only those that are not in the new errors table

Any ideas on how to do this...