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
Content-Type: text/plain; charset=us-ascii
You want something like this?
(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:
> 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