Then he posted to the wrong list :P

It would be interesting though if anyone knows how to do this on Oracle or MSSQL...

Best regards,

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: Rahul Chaudhari [mailto:mysqldba-ezmlmshield-x38539937.[Email address protected]
Sent: Monday, October 29, 2007 11:56 AM
To: LazyDBA Discussion
Subject: Re: Multiple Rows

I think he wants in oracle an not in mysql database.

Regards,
Rahul Chaudhari
----- Original Message -----
From: "Αναστάσιος Ξ Ξ±Ο€Ξ±Ξ΄ΟŒΟ€ΞΏΟ…Ξ»ΞΏΟ‚ "
<mysqldba-ezmlmshield-x19150961.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, October 29, 2007 1:12 PM
Subject: RE: Multiple Rows


> 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
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mysqldba-[Email address protected]
> Website : http://www.LazyDBA.com
>
>




---------------------------------------------------------------------
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