We were hoping for an example or a suggestion ...not a book advert.

Anthony Molinaro wrote:
> I show how to do it in oracle, mysql, db2, postgresql and sql server in my book:
>
> http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Molinaro/dp/0596009763/ref=pd_bbs_sr_2/103-2289700-5418224?ie=UTF8&s=books&qid=1193668116&sr=1-2
>
> There are many ways to do it, I highlight a few in my book (I also show an alternative for Oralce online using the MODEL clause in 10g
> On the errata page of my book on the oreilly site).
>
> Of all the db's though, I'd say that mysql's group_concat is the best builtin for this sort of problem.
>
> Regards,
> Anthony
>
> -----Original Message-----
> From: Αναστάσιος Παπαδόπουλος [mailto:mysqldba-ezmlmshield-x19036192.[Email address protected]
> Sent: Monday, October 29, 2007 5:13 AM
> To: LazyDBA Discussion
> Subject: RE: Multiple Rows
>
> 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
>
>
>
> ---------------------------------------------------------------------
> 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