SUB QUERY SELECT

17 Aug 2006 4:08 PM

robken

Hi all,
Just a quick question...can anyone tell me if SQL allows you
SELECT...FROM (sub query) WHERE...etc?
i.e is this query possible without first inserting the sub query data
into a temp table?

SELECT place1, SUM([value]) FROM (
SELECT place1, place2, [value] FROM flow WHERE prodid = 1
) GROUP BY place1

Thank you.

17 Aug 2006 4:19 PM

Tom Cooper

It does (it's called a derived table), and your syntax is almost correct.
You just have to give your derived table a name. I've called it x in the
code below

SELECT place1, SUM([value]) FROM (
SELECT place1, place2, [value] FROM flow WHERE prodid = 1
) x GROUP BY place1

Tom

Show quote

"robken" <robin.kenn***@hotmail.co.uk> wrote in message
news:1155830925.867070.19100@b28g2000cwb.googlegroups.com...
> Hi all,
> Just a quick question...can anyone tell me if SQL allows you
> SELECT...FROM (sub query) WHERE...etc?
> i.e is this query possible without first inserting the sub query data
> into a temp table?
>
> SELECT place1, SUM([value]) FROM (
> SELECT place1, place2, [value] FROM flow WHERE prodid = 1
> ) GROUP BY place1
>
> Thank you.
>