Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL statement problem ?
Message
From
04/11/1998 14:43:33
 
 
To
04/11/1998 14:36:21
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00154383
Message ID:
00154484
Views:
22
>yes i using vfp3.0
>so how to solve the problem?

This case the last SELECT will look differently:
SELECT tmp1.item_name,tmp1.quantity1,tmp2.quantity2 ;
 FROM tmp1,tmp2 ;
 INTO CURSOR tmp3 ;
 WHERE tmp1.item_name=tmp2.item_name ;
 UNION SELECT tmp1.item_name,tmp1.quantity1,0 as quantity2 ;
 FROM tmp1 ;
 WHERE tmp1.item_name NOT IN (SELECT item_name FROM tmp2) ;
 UNION SELECT tmp2.item_name,0 as quantity1,tmp2.quantity2 ;
 FROM tmp2 ;
 WHERE tmp2.item_name NOT IN (SELECT item_name FROM tmp1) 
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform