OUTER JOIN
select e.name, d.dept_id, d.name from s_emp e LEFT OUTER JOIN s_dept d ON e.dept_id = d.dept_id; select e.name, d.dept_id, d.name from s_emp e, s_dept d where e.dept_id = d.dept_id(+); select e.name, d.dept_id, d.name from s_emp e RIGHT OUTER JOIN s_dept d ON e.dept_id = d.dept_id; select e.name, d.dept_id, d.name from s_emp e,s_dept d where e.dept_id(+) = d.dept_id; select e.name, d.dept_id, d...
2015. 7. 16.