Child query

Hello,
https://imgur.com/a/9kx4g
that is my data model. Each user has multiple childs with another user id.... I want to return all users except those who are listed in a child of that user.... Could you please help me how i can filter / query this problem?

Its like this in SQL:
SELECT a FROM table1 WHERE a NOT IN (SELECT a FROM table2)

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.