Complex pivoting.. 1

[pgferro]

Hi Guys,
this is a tough one, for me...
I'm working on a ecommerce db migration, this is the basic structure :

description
price
image
category
subcategory1
subcategory2
subcategory3
subcategory4
subcategory5

There are 8,000 records, 6,000 of which are same items present in different categories/subcategories, these are the ones I'm having trouble with.
So a practical scenario :

Cell Phone ABC
200
img.png
Cell Phones
Quad Band
Unlocked


Cell Phone ABC
200
img.png
Cell Phones
Quad Band
T-Mobile

The result I would like to achieve :

Cell Phone ABC
200
img.png
Cell Phones/Quad Band/Unlocked,T-Mobile

Any ideas ???

Thanks !!!!

 

[r937]

use the GROUP_CONCAT function

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[pgferro]

Thanks !
I have to loop through the set, but it gets the job done !