>>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 never use this syntax probably because I think it's not as intuitive as a UNION. IAC, that's a workaround, such as I did with GO TOP, which is a real mystery in regards to the original problem. :)

It isn't workaround but rather different way to achive the same result.