>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. :)