Nested select statement in SQL Server
Nested select statement in SQL Server
Nested select statement in SQL Server
Re: Nested select statement in SQL Server
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
```
```
SELECT name FROM (SELECT name FROM agentinformation) a
```
or to be more explicit
```
SELECT a.name FROM (SELECT name FROM agentinformation) a
```