조인

select * from dept;

select * from member;

SELECT dept.dept_name,member.name FROM DEPT,MEMBER

where dept.dept_id=member.dept_id;

select t.dept_name ,s.name from member s, dept t

where s.dept_id=t.dept_id;

--ansi

select t.dept_name ,s.name from member s inner join dept t

on s.dept_id=t.dept_id;

--outer join

select s.dept_name,t.name from dept s left outer join member t

on s.dept_id=t.dept_id;

--right outer join

select s.dept_name,t.name from dept s right outer join member t

on s.dept_id=t.dept_id;

--right outer join

select s.dept_name,t.name from dept s , member t

where s.dept_id=t.dept_id(+);

--부서가 총무부인 사원의 이름을 출력하세요

select t.name from dept s, member t

where s.dept_id=t.dept_id

and s.dept_name='총무부';

--self join

select s.name,t.name from member s, member t

where s.member_id=t.mgr;

select s.name,t.name from member s left outer join member t

on s.member_id=t.mgr;