Thanks a lot for all the help nevertheless.

Kind regards
Bhavbhuti

--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>
> You're right, Bhavbhuti, CTEs can only help getting cName of your original query, it will not help getting the ten iid fields on the same line (or rather, I do not know how to do that) in ten different fields.
>
> Set