Hello.
So it is clear now, that you should have 16 columns and to build dynamically the column headings. The usual way to do such things in SQL is prepared statements. See: http://dev.mysql.com/doc/refman/5.0/en/sqlps.html And good example of how to use them (though it is an article about stored routines) here: http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html You will need to use user variables as well: http://dev.mysql.com/doc/refman/5.0/en/example-user-variables.html CONCAT function: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Control flow functions: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html Correlated subqueries: http://dev.mysql.com/doc/refman/5.0/en/correlated-subqueries.html Hope that'll be enough to make your query work. Kraer, Joseph wrote: > Gleb, > > What I need to have is a total of 16 columns: issue ID, priority, > assigned (to), project name, category, status, last update date, > summary, product name, project name (not the same as before), change > requester, change type, requested completion date, lead, developer, > impacted dept. > > I have no problems generating the first eight or the last columns. The > seven in between are the issue as they are not columns per se. They are > cells in different tables. I need to extract the contents of certain > cells, based on certain IDs, to be used as the column headings in the > output to my query. Then, I need to look into other tables to fill > those columns. This is what I need help with: how do I generate those > columns? I guess they could be generated separately and then I could > put both of my outputs together. Unfortunately, time is running out. > > TIA, > > Joseph "Tito" Kraer > Business Systems Analyst > Taylor, Bean & Whitaker Mortgage Corp > > -----Original Message----- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 06, 2005 6:52 AM > To: mysql@lists.mysql.com > Subject: Re: Newbie Question: listing open issues regardless of project -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
