2011年2月24日 - UPDATE anothertable INNER JOIN (SELECT * ... you are using an awful feature of MySQL with respect to declaring the Group By columns.
stackoverflow.com