Hi:
>Using a WHERE on the Room_No and getting ONE unique set of consecutive >Singer_No in Singer_No ORDER. The following is the result I'm looking for.
SET ORDER TO 0
SELECT room_no,singer_no,song_no;
FROM MyTable ;
WHERE room_no = 1 ;
GROUP BY room_no ;
ORDER BY 2
VFP will pick first singer_no by natural order.
HTH,
--Paul