Subject Re: Common Table Expressions (“WITH .. . AS ... SELECT”)
Author Dmitry Yemanov
22.01.2015 21:13, Svein Erling Tysvær wrote:

> I guess you'Re right in that the CTE is called once for each iteration.

It's not about CTE, but about outer joins. Inner part of the left join
is always [re-]evaluated for the every outer row.