Selection predicate on an outer joined table

[gandolf989]

or, how about this one?

select emp.empno, emp.ename, dept.deptname
  from emp
  left outer join
     ( select deptno, deptname
         from 
        where LOCATION = 'TVM' ) dept
    on emp.deptno = dept.deptno;