Hi there, I have a situation where I am trying to cross reference entries based on (for example) date and cost center. So without specifying the cost center sites in advance, how could I get a table returned out of mysql like:
-------------------------------------------------------- This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. ___________________________________________ -Date - Site 1 - site 2 - site 3 - ------------------------------------------- -1/20/2007 - 4 - 3 - <null> - -1/21/2007 - 4 - 4 - 2 - -------------------------------------------- Where the number is a count of tickets or something from each site. So I don't know in advance what the column headers are but I do have that information in a table, referenced by date. Does that make any sense? Any ideas how best to go about this type of construction? Thanks, Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
