"Martin Moss" <[EMAIL PROTECTED]> wrote: > 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;
You are ordering by a constant: the string "tr.Amount". Since the string is the same for every row, you're not actually getting any ordering. What are you trying to accomplish with those quotes? Get rid of them, and you may get the results you want. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]