Error with FROM clause containing a subquery

Question

I was running this query in MSSQL:

SELECT * FROM (SELECT * FROM ABC)

It gives an error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near ')'.

This same command runs just fine on a DB2 database. I know this query doesn't make any sense I was just testing functionality.

So, are there certain features, eg., SELECT in FROM clause, that are not supported in MSSQL that are supported in DB2?

Try putting an alias on the subquery: SELECT * FROM (SELECT * FROM ABC) AS t. — Felix Pamittan
– Felix Pamittan, Commented Mar 18, 2015 at 13:13

Tanner · Accepted Answer · 2015-03-18 13:47:39Z

3

You just need to give the subquery an alias like so:

SELECT * FROM (SELECT * FROM ABC) subTable

Which translates to:

SELECT * FROM (SELECT * FROM ABC) as subTable

The AS is optional.

Tanner

22.8k9 gold badges70 silver badges89 bronze badges

answered Mar 18, 2015 at 13:13

Alexis Peters

1,6511 gold badge11 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Whilst the As is optional, missing it out is lazy and can cause lots of confusion! "If you don't alias it, it don't get in production"