CHILD PARENT NAME1 2 V12 0 V23 1 V34 2 V45 0 V5
I want to print CHILDNAME and its PARENTNAME . What would be the query ?
SELECT child.name AS child_name
, parent.name AS parent_name
FROM daTable AS child
JOIN daTable AS parent
ON parent.child = child.parent
This topic is now closed. New replies are no longer allowed.