Re: newbie question on WHERE...

correct syntax is
(job,empno) in (select etc...)

Hth,

Sybrand Bakker, Oracle DBA

"PC" <prabhaweb_at_netscape.net> wrote in message news:3A79771E.C100298C_at_netscape.net...
> 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 - 16:44:03 CST