[RESOLVED] Union in Access / SQL2005

[Snaper]

In Access 2000 this query works

Select STDEV(x) from (Select W1 as x from TAB Union All Select W2 from TAB)

In MS SQL 2005, I get an error: Incorrect syntax near ')'

ADO, ODBC connection, SQL Server driver.

[techgnome]

I'm not surprised.... STDEV() is probably an Access function... not part of the standard SQL functions... no... wait... alias your table...

Select STDEV(x) from (Select W1 as x from TAB Union All Select W2 from TAB) myData

-tg

[Snaper]

Thanks techgnome.
In Access and in SQL this query work fine.

Select STDEV(x) from (Select W1 as x from TAB Union All Select W2 from TAB) TAB

[techgnome]

Great! So if the problem is resolved, can you mark the thread resolved? You can do that by selecting the Thread Tools menu under the first post.

Thanks!
-tg