"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]

Reply via email to