Posted by Pankaj on 03/01/07 12:35

Hi,

My sql query is giving me multiple records - producers, masters and
models. I want to display all models belonging to a particular
producer in a table column seperated by comma. However, I am unable to
do so. All my records get displayed in a seperate row. How can I get
this done.

eg.

Table Producers
producer_id producer_name
1 A
2 B

Table Models
model_id
producer_id model_name
1
1 ABC
2
1 DEF
3
1 QWE
4
2 ASD
5
2 ZXC

I want results to be in the format

Producer Name Model Name
A ABC,
DEF,QWE
B ASD, ZXC


TIA

[Back to original message]