如何写这句SQL语句?

来源：百度知道 编辑：UC知道 时间：2024/07/07 09:49:34
用户表tabUser：id,username
记录表tabInfo：id,add-userid,edit-userid
其中： 添加用户add-userid对应tabUser.id
编辑用户edit-userid也对应tabUser.id

要列出：记录表ID，添加用户，编辑用户

这样的SQL句子该怎么写？

select a.id as 记录表ID,b.username as 添加用户,c.username as 编辑用户 from tabinfo a inner join tabuser b on a.add-userid=b.id inner join tabuser c on a.edit-userid=b.id

select [id],add_userid,edit_userid from tabInfo where tabInfo.add_userid = tabUser.id and tabInfo.edit_userid = tabUser.id; 好像这个SQL语句没多大用啊.

123

Select tabInfo.id, addUser.username, editUser.username
From tabInfo
left join tabUser addUser on tabInfo.add-userid=addUser.id
left join tabUser editUser on tabInfo.add-userid=editUser.id;