I have two tables:
I need all the names for the ids that has the A-B relationships to update.
So, I want table_Names to look like this after the SQL update;
How should the mySQL statement look like?
I tried this:
INNER JOIN table_relationship
ON table_Names.id = A.id
UPDATE table_Names AS t1 INNER JOIN table_relationship AS t2 ON t1.id = t2.A_id INNER JOIN table_Names t3 ON t2.B_id = t3.id SET t1.name = t3.name