条件:
1.表A 有字段 a_id,b_id,c_id,d_id
2.表B有字段id,name
3.表A的a_id,b_id,c_id,d_id和表B的id关联我想得到这样的结果a_id, name, b_id, name, c_id,name, d_id,name这个查询语句怎么写吖
1.表A 有字段 a_id,b_id,c_id,d_id
2.表B有字段id,name
3.表A的a_id,b_id,c_id,d_id和表B的id关联我想得到这样的结果a_id, name, b_id, name, c_id,name, d_id,name这个查询语句怎么写吖
select a.a_id,b.name,a.b_id,c.name,
a.c_id,d.name,a.d_id,e.name
from A a,B b,B c,B d,B e
where a.a_id = b.id(+)
and a.b_id = c.id(+)
and a.c_id = d.id(+)
and a.d_id = e.id(+)
where a_id=b.id(+)
and a_id=c.id(+)
and a_id=d.id(+)
and a_id=e.id(+)
select a.a_id,b1.name,a.b_id,b2.name,a.c_id,b3.name
from table_a a,table_b b1,table_b b2,table_b b3
where a.a_id = b1.id(+)
and a.b_id = b2.id(+)
and a.c_id = b3.id(+)
from A a
left join B b
on a.a_id=b.a_id