Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH recursive items(id, caption, parent) AS
- (SELECT * FROM test WHERE id = :p
- UNION ALL
- SELECT * FROM test t
- JOIN items i ON i.PARENT=t.id
- )
- SELECT * FROM items;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement