Re: WHERE IN - Query

In article <7fmrna$o4i$1_at_news.LF.net>,
  "Joerg Leute" <leute_at_itdesign.de> wrote:
> 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
>
> Yes, this is called a 'Pairwise Query'.

For example:

SELECT * FROM DEPT WHERE (DEPTNO,DNAME) IN (SELECT DEPTNO,DNAME FROM TEMP_DEPT); Will return all rows for DEPT that have a matching DEPTNO AND DNAME row in the TEMP_DEPT table.

HTH, Matt Weishan
Senior Oracle DBA Instructor
Greenbrier & Russel, Inc.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 11:25:10 CDT