I ask for an example, because the answer is different depending on what you're attempting to actually do.

It sounds like what you want to do is a join. Why won't a join work for you? Most inline SELECT queries can be rewritten as joins (and often perform better as joins).

Can you post an example of what you are _trying_ to do, in code that presumably doesn't work yet (or you wouldn't ask the question), and we can go from there in helping design a solution.

-Joe

On Mon, May 23, 2011 at 1:32 PM, vaibhav wadhera <vaibhavwadhera@gmail.com>wrote:

> I know we can return the single column as the result from > the in-line subquery. > > I am just trying to do return the Multiple columns from the inline Sub > query which i can use in the main where condition. > > Thanks > > On Mon, May 23, 2011 at 11:57 PM, Joe Matise <snoopy369@gmail.com> wrote: > >> Can you send the list an example of what you're trying to do? >> >> Thanks, >> >> -Joe >> >> >> On Mon, May 23, 2011 at 1:25 PM, vaibhav wadhera < >> vaibhavwadhera@gmail.com> 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 >>> >> >> > > > -- > Thanks & Regards > > Vaibhav wadhera >