110,538
社区成员
发帖
与我相关
我的任务
分享
SELECT A.*,B.b_name,B.r_time FROM A LEFT JOIN B ON A.b_id=B.b_id AND NOT EXISTS(SELECT 1 FROM B b_sub WHERE B.b_id=b_sub.b_id AND B.r_time<b_sub.r_time)
SELECT A.*,B.b_name,B.r_time
FROM
A LEFT JOIN B ON A.b_id=B.b_id AND NOT EXISTS(SELECT 1 FROM B b_sub WHERE B.r_time<b_sub.r_time)