110,567
社区成员
发帖
与我相关
我的任务
分享
select M.memberid,M.[name],M.mobile,S.schoolname,R.rolename from memberinfo M join schoolinfo S on M.schoolid=S.schoolid join roleinfo R on M.roleid=R.roleid
select a.memberid,a.name,a.mobile,b.schoolname,c.rolename from memberinfo a
left join schoolinfo b on a.schoolid = b.schoolid
left join roleinfo c on c.roleinfo=a.roleinfo