Hi Paul:

Your solution didn't work for me either ... thanks though. The GROUP BY cluase it killing me.

Please see my second post to Cetin. I still need help.

Thank you,

Mal

>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