select * from pandaa
select * from pandab
1.内连接=简单连接=等值[文]连接
select pandaa a ,pandab b where a.plan = b.id
--相当于
select pandaa a inner join pandab b on a.plan = b.id
2.外链接
2,1 右外链接
(+)在a表右侧,所以是右[章]外链接 即b表显示全部数据,a表根[来]据plan与b表id等值连[自]接,没有则显示null
select * from pandaa a ,pandab b where a.plan (+) = b.id
--相当于
select * from pandaa a right join pandab b on a.plan = b.id
2.2 左外链接
左链接 b表在(+)左侧为左链接,[红]以a表为基准,b表等值连接[色],没有则显示null
select * from pandaa a ,pandab b where a.plan = b.id(+)
--相当于
select * from pandaa a left join pandab b on a.plan = b.id
3.交叉连接 =笛卡尔积
select * from pandaa ,pandab b
--相当于
select *from pandaa cross join pandab
4.自然连接-两张表具有相[火]同名字和数据类型字段才可进[线]行自然连接,查询结果同笛卡[自]尔积
select *from pandaa natural join pandab