verschachtelte Query

[himitsu]

https://stackoverflow.com/questions/...ecursive-query

SQL-Code:

with recursive temptablename (id, name, parent_id) as (
  select     id, name, parent_id
  from       products
  where      parent_id = 19  -- Initialisierung

  union all
  select     p.id, p.name, p.parent_id
  from       products p
  inner join temptablename
  on         p.parent_id = temptablename.id  -- Rekursion

)
select * from temptablename;