Hi Robin, I think you are not using DISTINCT correctly ... try SELECT DISTINCT whatever instead of the ()s. Also, the use of * and DISTINCT together really makes no sense ... in the SQL, you are saying select only one record, then select everything, which are opposites.
Advertising
Don't mean to be rude, but I recommend picking up a good book on database theory. :) Regards, Matthew Moldvan System Administrator Trilogy International, Inc. -----Original Message----- From: Sparky Kopetzky [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 12:20 PM To: PHP DB Group Subject: [PHP-DB] Very confused with query Good morning!! I'm trying to select 1 and only one record from each user based on the last date from a transaction file. This is what I'm using and it's not even close. It seems DISTINCT does not work!! SELECT DISCTINCT(transaction_user_id), MAX(transaction_date), * FROM transaction; Could some kind soul help me figure this one out?? Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
