以下语句在access中应如何改写？

Question

select a.* from biao2 a inner join (select name,max(date) AS maxgdtime from biao2 group by name) b on a.name=b.name and a.date=b.maxgdtime
and a.name LIKE '%李%' order by a.ID

Answer 1

access不支持子查询，没办法改写。低效的办法是借助中间表。