Hi All, Happy new Year
I have a problem which I have struggled with for a couple of weeks now and can't find an answer. Hoping you guys and girls can help. I am creating an excel file from a mysql database. That I can do fine. I am using the following to pull the required data. "Select coderef,title, author, web_price, categoryid from list Order by categoryid" Now, categoryid is a numeric flag that refers to an alpha entry, description, in another table, categories. Categoryid is in a random order. Is there anyway that I can pull the data from the list table and alphabetically order it on the value of description all in one line as I use the query result elsewhere to build the excel file. Here's hoping regards Melanie ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
