Shawn, Glen, and everyone else, Thank you very much! I do believe that I have enough material to work on it now!
I appreciate your help very much! Joseph "Tito" Kraer Business Systems Analyst Taylor, Bean & Whitaker Mortgage Corp -----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 06, 2005 11:03 AM To: mysql@lists.mysql.com Subject: Re: Newbie Question: listing open issues regardless of project 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
