求教一条sql语句该如何写

求教一条sql语句该如何写

语句：
select table1.id,a1.姓名,table1.id1,a2.姓名 from table1
inner join table2 a1
on a1.id = table1.id
inner join table2 a2
on a2.id = table1.id1追问table1表中只有一个字段ID，没有ID1和ID追答table1有2个字段吧，是id和id2吧，语句：
select table1.id,a1.姓名,table1.id2,a2.姓名 from table1
inner join table2 a1
on a1.id = table1.id
inner join table2 a2
on a2.id = table1.id2

select aa.id,aa.姓名,bb.id,bb.姓名 from(select row_number rownum,id,姓名 from table2 where id in(select id from table1)) aa,
(select row_number rownum,id,姓名 from table2 where id in(select id2 from table1)) bb
where aa.rownum = bb.rownum

select a.id,b.name,a.id2,c.name
from 表1 a,表2 b,表2 c
where a.id=b.id
and a.id2=c.id

select a.id,b.姓名,a.id2,c.姓名 as 姓名2
from 表1 a
left join 表2 b on a.id=b.id
left join 表2 c on a.id2=b.id