Newsgroups: comp.databases.oracle
From: pen@esa.uucp (Peter Hjæresen)
Subject: Re: tricky query question
Organization: Dansk Data Elektronik A/S
Date: Fri, 11 Nov 1994 12:35:48 GMT
Message-ID: <1994Nov11.123548.18546@esa.uucp>
References: <khuisman.32.000E846A@wnet.gov.edmonton.ab.ca>
Lines: 16


khuisman@wnet.gov.edmonton.ab.ca (Ken Huisman) writes:


...


Try:

select id from table1 where id in ( select table1id from table2 
where blah blah blah...)

>Ken
>khuisman@wnet.gov.edmonton.ab.ca

pen@dde.dk