Hi:

I have a table:
ROOM_NO (int) ... SINGER_NO (int) ... SONG_NO (char)

The entire table usually looks like this:
ROOM_NO ... SINGER_NO ... SONG_NO
3 ...................... 1 ........................ 24
1 ...................... 2 ........................ 25
1 ...................... 3 ........................ 30
2 ...................... 3 ........................ 41
1 ...................... 3 ........................ 23
2 ...................... 2 ........................ 20
2 ...................... 3 ........................ 99
2 ...................... 3 ........................ 42
1 ...................... 1 ........................ 36
1 ...................... 5 ........................ 23
3 ...................... 4 ........................ 20
2 ...................... 6 ........................ 1

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.
ROOM_NO ... SINGER_NO ... SONG_NO
1 ...................... 1 ........................ 36
1 ...................... 2 ........................ 25
1 ...................... 3 ........................ 30
1 ...................... 5 ........................ 30

Although Singer_No 1 and 3 are in the table more than once for Room_No 1, I need the first occurance of the singer number only.

At first it seemed simple, but I got nowhere :o(

Thanks for your help.

Mal