一个比较常见的sql查询语句问题

[xh_zhou]

我现在有两张表，一张表有两个字段是另外同一张表的主键，例如：
a表：(Evdid,managerID,depManagerID,others)
b表：（userid,userName)
a表的Managerid,depManagerID都是b表的主键，现在我想通过一个语句查询出a表的所有记录，同时把Managerid,depManagerID替换成相应的Username,该怎么实现？？
谢谢！！！！！

[GoZheng]

SELECT a.Evdid,b.UserName AS ManagerID,C.UserName as depManagerID,a.others From A Outer left JOIN B ON A.ManagerID=b.UserID Outer left JOIN B表 C ON A.DepManagerID=C.UserID

[IronPromises]

select Evdid,
(select userName from b where userid = managerID) userName1,
(select userName from b where userid = depManagerID) userName2,
others
from a;

[昵称被占用了]

select a.Evdid,b1.userName as manager,b2.userName as depManager,a.others
from a,b b1,b b2
where a.managerID=b1.userid
and a.depManagerID=b2.userid

[N_chow]

SELECT a.Evdid,b.UserName AS ManagerID,b.UserName as depManagerID,a.others From A INNER JOIN B ON A.ManagerID=b.UserID AND A.DepManagerID=b.UserID

[hssfox]

学习