rekursives select

[omata]

SQL-Code:

with recursive x (id, ref, Anz, Artikel) as
(
select
  s.modell, s.referenz, s.anz, m.partnumber
  from stueckliste s
  join modelle m on m.id = s.referenz
  where s.modell = :id
union all
select
  s.modell, s.referenz, s.anz, m.partnumber
  from stueckliste s
  join modelle m on m.id = s.referenz
  inner join x on s.modell = x.ref
)
SELECT * 
FROM x x1
WHERE NOT EXISTS (SELECT *
                  FROM x
                  WHERE id = x1.ref)