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 >