SELECT Member.FName,Member.LName,Member.Numero FROM Reservation; INNER JOIN Member ON Reservation.NoMember=Member.Numero; UNION; SELECT Member.FName,Member.LName,Member.Numero FROM Other; INNER JOIN Member ON Other.NoMember=Member.Numero; ORDER BY LName INTO CURSOR Tempif executed from the code, doesn't grab the specific record from the Other table. However, doing this will make it work:
SELECT Other GO TOP SELECT Member.FName,Member.LName,Member.Numero FROM Reservation; INNER JOIN Member ON Reservation.NoMember=Member.Numero; UNION; SELECT Member.FName,Member.LName,Member.Numero FROM Other; INNER JOIN Member ON Other.NoMember=Member.Numero; ORDER BY LName INTO CURSOR TempWhat is causing such reaction?