34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT A.*
,u1.kc_name AS I8_name
,u2.kc_name AS I9_name
FROM xbk AS A
LEFT JOIN IUser AS u1 ON A.I8=u1.id
LEFT JOIN IUser AS u2 ON A.I9=u2.id
SELECT * FROM xbk AS A
LEFT JOIN IUser AS u1 ON A.I8=u1.id
LEFT JOIN IUser AS u2 ON A.I9=u2.id