>Here's what I did. I appears to work....i think :-)
>
>sele distinct v_terror.htc_id, 'old' as source ;
> from v_terror, valerrors ;
> where v_terror.htc_id NOT IN (select distinct valerrors.htc_id from valerrors) ;
>union ;
> select distinct valerrors.htc_id, 'new' as source from valerrors ;
> into cursor mycurse2

---

The distinct is not needed here
The union clause filters all the duplicate values.
Look in the help for select - sql for that