I have 3 tables on SQLite and like to update table1 based on the values from table3.
On MySQL:
UPDATE table1 t1
JOIN table2 t2 ON t2.id = t1.id
JOIN table3 t3 ON t2.id = t3.id
SET t1.name = 0 WHERE t3.name = 0;
I know, that SQLite no support UPDATE-JOIN, but I don't know, what is good solution without JOIN?
Aucun commentaire:
Enregistrer un commentaire