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

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.

1 Like

thx!I forgot it