Date:         Wed, 2 Oct 1996 10:06:25 -0400
Reply-To:     "Zuckier, Gerald" <Zuckier@CHIME.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Zuckier, Gerald" <Zuckier@CHIME.ORG>
Subject:      Re: Can SQL do this?

You need to run a subquery, which selects the id #s of whoever has an
Acura; then select for any row with an id # in that subquery and also a
Porsche.
something like
 
proc SQL;
   create table myquery as
   select id
   from customer
   where id in
      ( select id
         from autos
         where id in
      ( select id
         from autos
         where  car='Acura' )
 and
 car='Porsche'
     )
You're on your own as to getting this into a user definable AF query.