oracle表连接

?

create table a(
aid number,
aname varchar2(20)
);
create table b(
bid number,
bname varchar2(20)
);

create table c(
cid number,
cname varchar2(20)
);

insert into a(aid,aname)

SELECT 1,‘a1‘ FROM dual
union all
SELECT 2,‘a2‘ FROM dual;

insert into b
SELECT 1,‘b1‘ FROM dual;

insert into c
SELECT 2,‘c2‘ FROM dual
union all
SELECT 1,‘c1‘ FROM dual;

commit;

?

1、SELECT * FROM a left join b on a.aid=b.bid left join c on c.cid= a.aid;

结果：

2、SELECT * FROM a left join b on a.aid=b.bid left join c on c.cid= b.bid;

3、SELECT * FROM a left join b on a.aid=b.bid right join c on c.cid= b.bid;

4、SELECT * FROM a inner join b on a.aid=b.bid right join c on c.cid= b.bid;

5、SELECT * FROM a inner join b on a.aid=b.bid left join c on c.cid= b.bid;

6、SELECT * FROM a cross join c

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!