I have my top level query with a subquery that I need to filter based on a calculated field in the subquery that returns true or false.
When I add the subquery criteria to my second query I get an error, Invalid Column Name: false.
It is basically saying the result of the calculated field is an invalid column.
Can you even do subquery criteria within a subquery?
In general I’d say yes, but without knowing specifics, hard to tell what might apply in your case.
Can you can post details for us to look at?
My Guess
If your column name is false, or you set the result of the calculation to false it is going to yell
false in SQL is 0 true is 1
That was it. False works in the the main query but must be 0 in the other subquery critera.
It should be 0 everywhere to be consistent.