Date:         Mon, 23 May 2011 17:34:11 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Regarding Multiple columns being returned from a Sub query
Comments: To: vaibhav wadhera <vaibhavwadhera@GMAIL.COM>
In-Reply-To:  <BANLkTinTwD=sqcNfpRFC7rSBLEVeKep3KQ@mail.gmail.com>
Content-Type: text/plain; charset=us-ascii

You want something like this?

   select
      *
   from
      a
   where
      (b, c) in (select b, c from someothertable)
   ;


It is supported in some other implementations of SQL, and I think it would be useful (and have asked for it in the past), but it's not allowed in SAS.




On May 23, 2011, at 11:25 AM, vaibhav wadhera wrote:

> Hi
>
> I would like to know that whether we can returns multiple columns from
> the inline sub query which we can use in our main select statement.
>
> --
> Thanks & Regards
>
> Vaibhav wadhera