Posted by Jim Lawton on 06/23/07 06:32

On Fri, 22 Jun 2007 21:30:17 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Jim Lawton (usenet1@jimlawton.TAKEOUTinfo) writes:
>> This (demo) statement is fine in Access, and so far as I can see, should
>> be OK in SQL Server.
>>
>> But Enterprise Manager barfs at the final bracket. Can anyone help
>> please?
>>
>> select sum(field1) as sum1, sum(field2) as sum2 from
>> (SELECT * from test where id < 3
>> union
>> SELECT * from test where id > 2)
>>
>> In fact, I can reduce it to :-
>>
>> select * from
>> (SELECT * from test)
>>
>> with the same effect - clearly I just need telling :-)
>
>In SQL Server, you need to provide an alias for the derived table:
>
> SELECT * FROM (SELECT *FROM test) AS x


Thanks to both you and Roy.
--
Jim
a Yorkshire polymoth

[Back to original message]