sorry, I had some extraneous quotes in my perl code:-) zzzzzzzzzzz ----- Original Message ----- From: "Martin Moss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 15, 2003 11:17 PM Subject: Order By question
> I have a query:- > SELECT recTran.TransactionID,tr.* FROM Transaction tr LEFT OUTER JOIN > ReconciledTransactions recTran ON recTran.TransactionID = tr.TransactionID > WHERE tr.ReconciliationID = '8' HAVING recTran.TransactionID IS NULL ORDER > BY 'tr.Amount' DESC; > > The problem I have is that the Order By doesn't seem to be returning the > results in the order I expect. Can anybody shed any light on this? > > I am expecting to see the data returned ordered overall by the order_by > clause, however it doesn't do this. > > Regards > > Marty > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.516 / Virus Database: 313 - Release Date: 01/09/2003 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 02/09/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]