Hello Everyone,
I am creating Node Graph using MYSQL. I am able to create it from A to B but not able to manage from B to C
Node query is -
SELECT A AS id FROM Table1 WHERE A= ‘$value’
UNION
SELECT B AS id FROM Table1 WHERE A = ‘$value’
UNION
SELECT C FROM Table2 WHERE B IN (SELECT B FROM Table1 WHERE A = ‘$value’)
Edge query -
SELECT A AS id, A As source, B AS target FROM Table1 WHERE A = ‘$value’
UNION
SELECT B AS id, B As source, C AS target FROM Table2 WHERE B IN (SELECT B FROM Table1 WHERE A = '$value
')
Please help I am trying to create like this A —>B—>C. Already achieved A—>B