Re: Problem with referring column from double nested subquery
Posted by:
Ert ong
Date: September 25, 2013 01:24AM
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?
Subject
Written By
Posted
September 21, 2013 08:39AM
September 22, 2013 09:20PM
September 22, 2013 11:59PM
September 23, 2013 07:27PM
September 24, 2013 01:33AM
September 24, 2013 09:44AM
September 24, 2013 01:53PM
September 24, 2013 03:10PM
Re: Problem with referring column from double nested subquery
September 25, 2013 01:24AM
September 25, 2013 10:28AM
September 25, 2013 11:05AM
September 25, 2013 04:49PM
September 26, 2013 02:04AM
September 24, 2013 09:10PM
September 25, 2013 12:45AM