SQL Query to get orphaned nodes
Posted on 2014-11-11
I have an interesting query that I am trying to create...
I have a table that contains entities, each of these *may* have a parent (only single level)
What I would like to do is query the table to find entries that say they have a parent, but the parent entry does not exist.
ID, DESCRIPTION, PARENT
In this example, I would like to execute a query to get the record relating to 'E'
I've tried a few ways, but can't get it to work!!!
Any ideas would be very much appreciated..
Thanks a lot,