Re: nesting select statments

From: <ashesh48_at_my-dejanews.com>
Date: Fri, 12 Jun 1998 16:43:53 GMT
Message-ID: <6lrls9$psi$1@nnrp1.dejanews.com>

In article <357E2993.F23048A5_at_scientia.com.au>, Bruce Woodward <bruce_at_scientia.com.au> wrote:
>
> Hi,
>
> Is it possible to nest select statments? eg
> select something, something, something, (select something from
> something)
> from something
>
> thanks in advance,
> Bruce
>
>

U can do something like this..
select a.column1, b.column1, c.column2 from table1 a, table2 b, table3 c

And u can also write the subquries..
Ashesh.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 12 1998 - 11:43:53 CDT