By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | groups | types |
|---|---|---|
| 1 | AB | SomeValue |
| 2 | BC | SomeValue |
| product | subgroup | types |
|---|---|---|
| A | XX-AB-XX-text | SomeValue |
| B | XX-BC-XY-text | SomeValue |
| id | groups | types | product | subgroup | types |
|---|---|---|---|---|---|
| 1 | AB | SomeValue | A | XX-AB-XX-text | SomeValue |