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
Thanks in Advance.
J. Turner