merge rows of data within a table

[hrgilley]

I hope someone here can help me. I am trying to merge rows of data within a table. Here's what I have

Guest id: Row: Section: Seat:
567 A CC 102
567 A CC 103
567 A CC 104

What I need to get is one row that says:

Guestid: Seats:
567 ACC102 - 104

Can anyone help me?

[Motoma]

I hope someone here can help me. I am trying to merge rows of data within a table. Here's what I have

Guest id: Row: Section: Seat:
567 A CC 102
567 A CC 103
567 A CC 104

What I need to get is one row that says:

Guestid: Seats:
567 ACC102 - 104

Can anyone help me?

[code=sql]
SELECT Guest_ID, Row, Section, MIN(Seat) AS First, MAX(Seat) AS Last FROM Table GROUP BY Guest_ID. Row, Section
[/code]

[hrgilley]

Thanks! I'll try that!