Dataflow chain¶
If the resultset of a subquery or CTE is used in the from clause of the upper-level statement, then the impact of the lower level resultset will be transferred to the upper-level.
1 2 3 4 5 6 7 8 9 10 11 |
|
In the CTE, there is an impact relation:
1 |
|
Since cteReports
is used in the from clause of the upper-level statement, then the impact will carry on like this:
1 |
|
If we ignore the intermediate resultset, the end to end dataflow is :
1 2 |
|
diagram
