i have the following query working perfectly with Dbase 4, but it crashes in mysql :
SELECT SUM(DISTINCT A.AMOUNT) AS AMT FROM table1 A
I'd like to get that amount in only one query if possible, even though i could do it by using a temporary table, selecting into it all the distinct amounts, and then sum them.
Can somebody give me an alternative query? Thanx.
SQL SQL
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
