You should try the group_concat function in MySQL, a great feature missing in most RDBMS (AFAIK).
HTH,
Anastasios Papadopoulos
Αναστάσιος Παπαδόπουλος
Software Solutions Architect
SalesManager Hellas
Customer Relationship Management Solutions
Τηλ.: (+30) 210 6083485
Φαξ: (+30) 210 6018453
e-mail: [Email address protected]
www.salesmanager.gr
-----Original Message-----
From: Spencer Gregory A IT2 (LAS CC) [mailto:mysqldba-ezmlmshield-x30149568.[Email address protected]
Sent: Sunday, October 28, 2007 9:45 PM
To: LazyDBA Discussion
Subject: Multiple Rows
I have an assignment to create a Movies database with the movie listed
along with the actors. My problem is I need to display each movie one
time along with all the actors;
Cold Mountain- Jude Law, Nicole Kidman
Enemy at the Gates- Jude Law, Rachel Weisz
But what I get is like this;
Cold Mountain- Jude Law
Cold Mountain- Nicole Kidman
Enemy at the Gates- Jude Law
Enemy at the Gates- Rachel Weisz
How do I avoid displaying duplicating the movie title?
Very respectfully,
IT2 Spencer
CCNA
[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com
MySQL LazyDBA home page