add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
OrganizationTypeID OrganizationTypeID ParentName ChildName res
1 1 parent parent parent
1 2 parent child 1 parent>child 1
1 3 parent child 2 parent>child 2
1 5 parent parent 5 parent
5 1 parent 5 parent parent 5
5 2 parent 5 child 1 parent 5>child 1
5 3 parent 5 child 2 parent 5>child 2
5 5 parent 5 parent 5 parent 5
OrganizationTypeID ParentOrganizationTypeID Name childname res
1 null parent parent parent
1 2 parent child 1 parent>child 1
1 3 parent child 2 parent>child 2
5 null parent 5 parent 5 parent 5