Hello Roy,

would that work for you?

SELECT * FROM TEST WHERE PARENT IN (SELECT ID FROM TEST) UNION SELECT A.* FROM TEST A, TEST B WHERE A.ID=B.PARENT