From: Peter Kallweit <kallweit@iief.de>
Newsgroups: comp.databases.oracle.misc
Subject: Re: newbie question on WHERE...
Date: Fri, 02 Feb 2001 08:17:51 +0100
Organization: IIEF GmbH
Lines: 20
Message-ID: <3A7A5F1F.71E466D5@iief.de>
References: <3A79771E.C100298C@netscape.net>
NNTP-Posting-Host: helmut.iief.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: rhodos.FTA-Berlin.de 981098859 22006 141.16.93.179 (2 Feb 2001 07:27:39 GMT)
X-Complaints-To: usenet@rhodos.fta-berlin.de
NNTP-Posting-Date: 2 Feb 2001 07:27:39 GMT
X-Mailer: Mozilla 4.72 [en]C-CCK-MCD QXW0323l  (WinNT; U)
X-Accept-Language: de,en


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