Re: Need Help with SQL

From: Ken Hinerman <hinerman_at_DataInteraction.com>
Date: 2000/07/06
Message-ID: <8k3cho$oq9$1@bob.news.rcn.net>#1/1

It will pull matched records only, don't know what you want but if you want a cross section from both tables try

select account no, ssn
from T1
UNION [INTERSECT -- Distinct records from both tables] select account no, ssn
from T2

Ken

Brian Vuong <brian-vuong_at_usa.net> wrote in message news:sm9sqlsbgas30_at_corp.supernews.com...   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