Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql statement question.....
Message
 
To
19/01/2001 16:43:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00465939
Message ID:
00466030
Views:
13
>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
Map
View

Click here to load this message in the networking platform