>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...
What about first selecting all the errors and then do the final select.\
SELECT * from newerror;
union;
select * from olderror;
into cursor allerrors
Select ...... from htc, allerrors;
where htc.id = allerrors.id