..."The specified field could refer..." Error

[udigold1]

Hi,
I'm trying to do a nested select query But I keep getting the aforementioned error. I Don't get it....
Can you please help? Thanks!
Here's the query:

SELECT distinct tabledesc.field1 FROM
(SELECT TableDesc.id from Tabledesc) Tabledesc

 

[james_lankford]

first, there is no field named field1 in the subquery

second, why even use a subquery ?
jsut write it like this
SELECT distinct TableDesc.id from Tabledesc

but if you really want/need a subquery then do

SELECT distinct tbl.field1 FROM
(SELECT TableDesc.id as field1 from Tabledesc) as tbl

 

[udigold1]

Hi, thanks.
It's a simplified version for what I need. I've narrowed it down to the part that gives me the error...
Thanks again,