Re: Transpose row into column
Posted by:
brian
Date: April 23, 2005 11:23PM
You might be able to get something approximating what you desire with GROUP_CONCAT() which is available in 4.1 and later.
Though you really should consider reorganizing your tables, using normalization. Having the same information (e.g. "Site A") duplicated in more than one row is not a good idea. Ideally you'd have three tables: one storing (site_id, site_name), one storing (part_id, part_name) and the third expressing the many-many relationship between them (site_id, part_id, quantity). If you arrange things in this manner then you can query the relationships easily without the contortions you're going to have to go through with your current setup.
Subject
Views
Written By
Posted
57175
April 21, 2005 01:25AM
Re: Transpose row into column
29155
April 23, 2005 11:23PM
25840
April 24, 2005 11:32PM
42731
May 12, 2005 05:26AM
24828
November 21, 2005 10:16AM
18337
October 09, 2006 01:46AM
21406
January 04, 2007 05:03PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.