This one works, just change the fields...

SELECT transaction_user_id, Max(transaction_date) AS transaction_max_date, *
FROM transactions group by transaction_user_id;

This works... but I tried it on a number field instead of date... but it
should handle the same way...

Ronald Villarosa
www.pabahay.com
www.bullsandbears.net
www.2datop.com


"Sparky Kopetzky" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
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

Reply via email to