oracle表的连接,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