Nested select statement in SQL Server

November 24, 2022 by Tarik

You need to alias the subquery.

SELECT name FROM (SELECT name FROM agentinformation) a

or to be more explicit

SELECT a.name FROM (SELECT name FROM agentinformation) a