Dear Jeff,

i want to calculate parents id which have both child left and right.

this is my table.

id, parentid, left_child, right_child

1 1 ...

i am creating binary mlm project i have no idea about it

i got query about how to calculate left and right child.

but i need to calculate numbers of pairs in...