> Hello,
>
> at the moment, I’m in struggle with a CTE:
>
> for with recursive ok as
> (select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner
> join t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom =
> :id_kom union all select c.pos, d.kennzeichen, d.price, d.id from
>
> Hello,
>
> at the moment, I’m in struggle with a CTE:
>
> for with recursive ok as
> (select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner join
> t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom = :id_kom
> union all
> select c.pos, d.kennzeichen, d.price, d.id from
?
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 2. Mai 2017 16:36
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] question cte separately
Hello,
at the moment, Im in struggle with a CTE:
for with recursive ok as
(select
Hello,
at the moment, Im in struggle with a CTE:
for with recursive ok as
(select a.pos, b.kennzeichen, b.price, b.id from t_l_prkom_grp a inner join
t_l_prkom_grp_pos b on a.id = b.id_kom_grp where a.id_kom = :id_kom
union all
select c.pos, d.kennzeichen, d.price, d.id from t_l_prkom_grp c