Re: [GENERAL] Denormalizing via SQL

2011-12-11 Thread David Johnston
On Dec 11, 2011, at 19:40, Robert James wrote: > I have a query returning: > > name | product_id > Bob | 1 > Bob | 2 > Charles | 1 > Charles | 4 > > To make it compatible with a legacy app, I need to convert it to this form: > name | product_ids > Bob | "1,2" > Charles | "1,4" > > (Before you

[GENERAL] Denormalizing via SQL

2011-12-11 Thread Robert James
I have a query returning: name | product_id Bob | 1 Bob | 2 Charles | 1 Charles | 4 To make it compatible with a legacy app, I need to convert it to this form: name | product_ids Bob | "1,2" Charles | "1,4" (Before you jump "That's not normal!" - I know. I didn't write the app. I just need to