3,491
社区成员
发帖
与我相关
我的任务
分享
select (select t2.BLICTYPE
from (select tt.*,
row_number() over(partition by tt.MARPRID ORDER BY tt.OPFROM DESC, ID DESC) as rn
from 表1 tt) t2
where t2.rn = 1
and t.id = t2.MARPRID) LICENSE_TYPE
from 表2 t