-- 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 -- [Joe Stefanelli] [so/q/4629979] [cc by-sa 3.0] $Follow @igor_chubin cheat.sh