hello everybody.

currently i have the following (simplyfied):

sele a.idfld ;
   from 'history\frames' a ;
   where SomeCondition ;
   into cursor cur_temp1

sele a.idfld ;
   from 'current\frames' a ;
   where ;
      SameCondition .and. ;
      a.idfld not in (select temp.idfld from cur_temp1) ;
   into cursor cur_temp2

(make cur_temp1 read/write)

sele cur_temp1
append from cur_temp2
use in cur_temp2

is there a better, more propper way of doing this (preferably with 1 sql command)?

thanks for all your help!