mysql subquery join ?????????

星期三, 22nd 七月 2009

select * from write_Art a join
 (SELECT wc_id, MAX(wa_date) AS aa FROM write_Art GROUP BY  wc_id)b where a.wa_date = b.aa

????????????,??sql??????????????,??????????????????

?????MySQL 4.1?????????