the problem i had, described in the other message, i fixed by just opening the current table and the history table, prior to running the querry.
i think that the sql got confused, because the 2 tables have the exact same name, they are just in 2 different folders. i think that's why the result came back with 0 records (the history table is empty at this time).
by pre-opening them with different aliases the problem was solved.
Thanks Fred!
>
>SELECT hist.idfld1 FROM history\frames hist ;
> WHERE SomeCondition ;
> UNION ALL ;
> SELECT cur.idfld1 FROM current\frames cur ;
> WHERE SomeCondition AND cur.idfld1 NOT IN (SELECT idfld1 FROM history\frames WHERE Somecondition) ;
> INTO CURSOR combined
>
>I think that should work.