Re: newbie question on WHERE...

Do it this way :

select deptno
from emp
where (job, empno) IN

      (select job, empno
       from emp
       where ename='CLARK');

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 16:36:05 CST