SELECT  E.empno,
        D.dname
FROM    emp E,
        dept D
WHERE   E.deptno = D.deptno
AND     (D.deptno = :vardept
OR      E.empno = :varemp);