I don't know if they fixed it in MySQL 5 but here's the warning I had to deal with in 4:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html Not right on so many levels.... I work with Firebird now. mg On 1/19/07, Patrick Crowley <[EMAIL PROTECTED]> wrote:
Not to answer my own question, but I think I have it: SELECT item_id, MAX( amount ) FROM `bids` WHERE proxy !=1 GROUP BY item_id -- Patrick _______________________________________________ Sdruby mailing list [email protected] http://lists.sdruby.com/mailman/listinfo/sdruby
_______________________________________________ Sdruby mailing list [email protected] http://lists.sdruby.com/mailman/listinfo/sdruby
