Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Need Help with SQL

Need Help with SQL

From: Brian Vuong <brian-vuong_at_usa.net>
Date: 2000/07/06
Message-ID: <sm9sqlsbgas30@corp.supernews.com>#1/1

Please tell me if this query is pulling all accounts or just pulling matched ssn accounts

Select acctno, ssn
From TABLE1
Where ssn in

           (select ssn
             from TABLE2)

;

Thanks,

Brian

--
Received on Thu Jul 06 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US