Re: Problem with referring column from double nested subquery

[Ert ong]

Thanks, but as I said, we are talking about different things.

You are passing the field `whatever` from the INNER to the OUTER query.
In this case I completely agree with your position and standard position.

But the problem arises when we need to do the opposite: make nested subquery to be depended from the field of the outer table.

SELECT *, (SELECT * FROM (SELECT D.date ) B ) A
FROM Days D;

Here D - is the OUTER table. And for every it's row I want to compute the result of query A, which depends on result of query B, which depends on the value of column D.date of the very first table D.

And this is the thing I cannot do for some reason.

Let's think in a different way:
Is query above syntactically correct?
If yes, why is does not work?