SELECT d.deptno,substr(d.dname,1,7)"dname" ,d.loc,
e.ename, e.job FROM dept d inner join emp e ON d.deptno = e.deptno
where d.deptno in(10, 30) order by d.deptno
full outer join
SELECT d.deptno "dno",substr(d.dname,1,7)"dname"
,substr(d.loc,1,5)"loc", e.ename, e.job FROM dept d full outer join
emp e ON d.deptno = e.deptno where e.deptno in(10, 30) order by
d.deptno