<세미조인 예제>

select a.*
from emp a
where a.deptno in(
    select b.deptno
    from dept b
    where b.loc = 'DALLAS')