[RESOLVED] Union in Access / SQL2005

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.

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

Code:

---

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

---

-tg

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

Code:

---

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

---

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