jeudi 29 janvier 2015

sqlite inner join update - 3 tables

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