SELECT
a.A0100,
a.a0101,
a.A01BN,
a.A01BQ,
a.A01BR,
a.A0144,
a.E0122,
a.A01DE,
b.I9999,
b.A7126,
b.A7102,
b.A7105,
b.A7110
FROM
usra01 a
LEFT JOIN ( SELECT a0100, max(I9999) as i99991 FROM usra71 GROUP BY a0100 ) AS c ON a.a0100 = c.a0100
LEFT JOIN usra71 b on b.a0100=c.a0100 and c.i99991=b.I9999
WHERE a.B0110 LIKE 'Z60%' or a.A0144='19920003'
多表关联、取其中子表最后一条数据
最新推荐文章于 2024-07-11 20:24:07 发布