Why does the following not function?
SELECT name FROM (SELECT name FROM agentinformation)
I must not have fully grasped SQL because I would have assumed that this would produce the same result as:
SELECT name FROM agentinformation
Doesn't the inner select statement provide a result set that is then queried by the outer SELECT query?