Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UNION does not get the record on specific environment
Message
 
 
To
12/11/2002 16:14:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00721818
Message ID:
00721921
Views:
10
Hi Michel,

I've no idea why it doesn't work the way it suppose to but I think you can get desired result w/o UNION. Try
SELECT Member.FName, Member.LName, Member.Numero ;
	FROM Member ;
	WHERE Member.Numero  IN ( SELECT NoMember FROM Reservation)
		OR Member.Numero IN ( SELECT NoMember FROM Other)
>I just found something weird that I am looking to get some additional information on. It is in regards to a UNION clause where, being executed from the command prompt works, but, when being executed from the code, if the cursor of the UNION table is at EOF(), does not grab the related record.
>
< snip >
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform