Posted by Jim Lawton on 06/22/07 21:19

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 :-)


cheers,
Jim
--
Jim
a Yorkshire polymoth

• Next in forum: Re: Unable to connect to SQL Server Express Locally or Remotely
• Prev in forum: Unable to connect to SQL Server Express Locally or Remotely
• Thread view: correct syntax for this select in SQL Server?

[Reply to this message]