|
|
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
Navigation:
[Reply to this message]
|