2019-01-22 ■ selectselect a.id ,b.date ,b.codefrom person a inner join anken b on a.id = b.personid inner join ( select personid ,max(date) maxdate from anken group by personid )T on b.personid = T.personid and b.date = T.maxdate