Why it got wrong? Cant I use x from out-select in sub-select?

[JayceS]

[flamber]

Hi @JayceS
The error comes from the database. Try running the query directly on the database. I'm guessing that you cannot reference a table in the select-clause, try adding the subselect as a join instead.

[JayceS]

thx！I forgot it