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