>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only