union all 사용예

select deptno
      ,min(job)
      ,sum(sal)
      ,min(dname)
      ,min(loc)
from (
      select
            deptno
           ,job
           ,sal
           ,'' as dname
           ,'' as loc
      from emp
union all
     select 
            deptno
           ,'' as job
           ,'' as sal
           ,dname
           ,loc
     from dept       
     )
group by deptno