combine Rows into a single Column

[webgod]

How do I change the sql statement bellow to make this:

+-----+-----+-------------+-------------------+---------+------------+------------+----------------------+
| cid 		| bid | b_name      | b_address         | b_image | b_city     | name       				 |
+-----+-----+-------------+-------------------+---------+------------+------------+----------------------+
|   2,78,80 | 662 | WINGATE INN | 3641 SANGANI BLVD |         | DIBERVILLE | Restaurant, SAUCIER, WIGGINS|
+-----+-----+-------------+-------------------+---------+------------+------------+----------------------+

select Business_Category.cid, Business.bid, Business.b_name, Business.b_address, Business.b_image, Business.b_city, Category.name from Business, Business_Category, Category where Business.bid=Business_Category.bid and Business_Category.cid=Category.cid
    -> ;
+-----+-----+-------------+-------------------+---------+------------+------------+
| cid | bid | b_name      | b_address         | b_image | b_city     | name       |
+-----+-----+-------------+-------------------+---------+------------+------------+
|   2 | 662 | WINGATE INN | 3641 SANGANI BLVD |         | DIBERVILLE | Restaurant |
|  78 | 662 | WINGATE INN | 3641 SANGANI BLVD |         | DIBERVILLE | SAUCIER    |
|  80 | 662 | WINGATE INN | 3641 SANGANI BLVD |         | DIBERVILLE | WIGGINS    |
+-----+-----+-------------+-------------------+---------+------------+------------+

[ultraslacker]

Worry about presentation in the application layer - do not try this with SQL.

[barand]

Set up a while loop to process your query result. As you do, store the cid's and only output on change of bid.