Xref: alice comp.databases.oracle.server:46682
Path: alice!news-feed.fnsi.net!newsfeed.ecrc.net!newsfeed.nacamar.de!newsfeed.nacamar.de!rz.uni-karlsruhe.de!news.uni-stuttgart.de!news.belwue.de!LF.net!not-for-mail
From: "Joerg Leute" <leute@itdesign.de>
Newsgroups: comp.databases.oracle.server
Subject: WHERE IN - Query
Date: Thu, 22 Apr 1999 11:57:39 +0200
Organization: LF.net GmbH, Internet Services, Stuttgart, Germany
Lines: 12
Message-ID: <7fmrna$o4i$1@news.LF.net>
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi everybody

Isn't it possible to extend a WHERE IN query over 2 columns - first column
is number and second is char) like

SELECT * FROM TABLE1 WHERE (ID, NAME) IN (SELECT ID_2, NAME_2 FROM TABLE2)

Thanks for your help

Joerg