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

Click here to load this message in the networking platform