newbie question on WHERE...

Can the WHERE clause take 2 variables in the same line? ie,

SQL> select deptno
  2 from emp
  3 where job, empno IN
  4 (select job, empno
  5 from emp
  6 where ename='CLARK');
where job, empno IN

         *
ERROR at line 3:
ORA-00920: invalid relational operator

I was trying to make the above query as one subquery instead of 2 subqueries. How else I can do this?

thanks so much,
nc Received on Thu Feb 01 2001 - 15:39:05 CST