帮我看看这种SQL咋写

[xzzxg]

有二张表
table1
id name
---------------
1 A
2 B
3 C

table2
userid id1 id2
---------------------
001 1 3
002 2 3
---------------------------------------
如何用查询返回以下效果：
userid id1 name1 id2 name2
----------------------------------------
001 1 A 3 C
002 2 B 3 C

[yujohny]

select userid,
id1,(select name from table1 where id =a.id1) name1,
id2,(select name from table1 where id =a.id2) name2
from table2 a

[pengdali]

select userid,id1,
(select name from table1 where id=table2.id1) name1,id2,
(select name from table1 where id=table2.id2) name2
from table2

[sdhdy]

select a.userid,a.id1,b.name name1,a.id2,c.name name2 from table2 a
left join table1 b on a.id1=b.id
left join table1 c on a.id2=c.id

[pengdali]

select a.userid,a.id1,b.name name1,a.id2,c.name name2 from table2 a join table1 b on a.id1=b.id join table1 c on a.id2=c.id

[dafu71]

select a.userid,a.id1,b.name name1,a.id2,c.name name2 from table2 a ,table1 b ,table1 c where a.id1=b.id and a.id2=c.id