While it is possible to pivot a table like that, the code is ugly, and does not work well if you need a variable number of columns.
SQL can do the JOIN to get a single resultset for the information, but the layout is best done in a application language, such as PHP. > -----Original Message----- > From: Mogens Melander [mailto:mog...@fumlersoft.dk] > Sent: Wednesday, November 14, 2012 12:23 AM > To: mysql@lists.mysql.com > Subject: Dynamic crosstab got me lost. > > Guru's > > I've been tasked with creating a report with information about which images > are related to each active article. The images are descriptive icons > visualizing different properties. > > Articles can be active 'on' or not '', and only active is to be included in > the result. > > The number of available icons changes constantly, and are too many, to use > anything static. > > What I got is: > > Table: main > ----------------- > code (int) > active (on/off) > ----------------- > > Table: icon > ----------------- > id (int) > filename (char) > ----------------- > > Table: iconrel > ----------------- > code (int) > icon (int) > ----------------- > > What I need is something like: > > code filename1 filename2 filename3 filenameN > 1111 on off off on > > Hopefully somebody out there got more of a clue than I do. > > Any ideas, anybody? > > -- > Mogens Melander > +66 8701 33224 > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql