Re: newbie question on WHERE...

Hi PC,
(crazy name)

PC wrote:
>
> Can the WHERE clause take 2 variables in the same line? ie,
>
> SQL> select deptno
> 2 from emp
> 3 where job, empno IN

       where (job, empno) IN

> 4 (select job, empno
> 5 from emp
> 6 where ename='CLARK');

hth
peter Received on Fri Feb 02 2001 - 01:17:51 CST