我现在有两个表,A和B:表A:
KEY CODE1 CODE2 CODE3
001 111 222 333表B:
KEY NAME
111 AAA
222 BBB
333 CCC现在有表A的一个key值'001',能不能用一句SQL实现下面的输出结果
表C:
KEY CODE1 NAME1 CODE2 NAME2 CODE3 NAME3
001 111 AAA 222 BBB 333 CCC
KEY CODE1 CODE2 CODE3
001 111 222 333表B:
KEY NAME
111 AAA
222 BBB
333 CCC现在有表A的一个key值'001',能不能用一句SQL实现下面的输出结果
表C:
KEY CODE1 NAME1 CODE2 NAME2 CODE3 NAME3
001 111 AAA 222 BBB 333 CCC
from A,B B1,B B2,B B3
where a.code1=b1.key
and a.code2=b2.key
and a.code3=b3.key
(id int,
ida int,
idb int,
idc int);
---
insert into ta values(1,111,222,333);
---
create table tb
(id int,
name varchar2(40));
---
insert into tb values(111,'aaa');
insert into tb values(222,'bbb');
insert into tc values(333,'ccc');
---
select a.id,b.id,b.name,c.id,c.name,d.id,c.name from ta a inner join tb b
on a.ida=b.id inner join tb c on a.ida=c.id inner join tb d on a.ida=d.id