with new_a as ( select * from a where (id,dt) in ( select id ,max(dt) from a group by id) ) select new_a.id, new_a.name, code from new_a full join b on new_a.id = b.id order by new_a.id 这样可以吗？