No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
UPDATE members a INNER JOIN members b on a.Recommended_By = b.ID set a.Node = CONCAT_WS('(',b.ID,')',b.Node) this statement to update node column from same table, but the problem is i have to execute many times to get the correct: example : ID Recommended_by Node 1 2 1 1 3 2 2 …
|
|
|
i run the below script to get the left and right as per the binary i did and it is ok Script select a.ID,a.Node,a.direction, a.Reference_ID, a.Recommended_By from members a JOIN members b ON a.Node LIKE CONCAT('%(',b.ID,')%') Where b.ID = 2 order by b.id,a.Recommended_By' Result **ID** **Node** **Direction** **Reference** **Recommended_By** 4 …
|
|
|