Subject Re: [firebird-support] Re: Why this sql not work ?
Author Mark Rotteveel
On Tue, 20 Mar 2012 10:46:31 -0000, "nathanelrick" <nathanelrick@...>
> it's a bad new that i have no way :(
> when i try the CTE, the prepare seam to grow ("seam" i just do now some
> tests). also CTE are a little hard to use in my situation ...

The use an inner select / subquery:

<whatever special logic you need>
FROM (SELECT <the fields you need and their aliases> FROM yourTable) A