Oracle连接查询

1、内连接

/*内连接返回满足条件的记录，其中inner可以省略*/select * from emp e inner join dep d on e.emp_dep_id = d.dep_id

?2、外连接

/*外连接返回满足条件的记录*/select * from emp e full join dep d on e.emp_dep_id = d.dep_id/*左外连接不仅返回满足条件的记录，而且还返回不满足条件的连接操作符左边表的记录*/select * from emp e left join dep d on e.emp_dep_id = d.dep_idselect * from emp e ,dep d where e.emp_dep_id = d.dep_id(+)/*右外连接不仅返回满足条件的记录，而且还返回不满足条件的连接操作符右边表的记录*/select * from emp e right join dep d on e.emp_dep_id = d.dep_idselect * from emp e ,dep d where e.emp_dep_id(+) = d.dep_id

?