SELECT hist.idfld1 FROM history\frames hist ;
WHERE SomeCondition ;
UNION ;
SELECT cur.idfld1 FROM current\frames cur ;
WHERE SomeCondition;
INTO CURSOR combined