I forgot to include the select statement I had written that seemed to
me like it would work.
SELECT `Table` . `Customer` , MAX(`Table`.`TransactionDate`) AS `Last
Update`, `Table` . `TransactionCode` FROM Table GROUP BY `Customer` ASC
It only returned the first record for each customer with the last
update, instead of the transaction code from that last transaction date.
Kevin
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
