dimanche 1 février 2015

Delete with Inner Join

I am performing this SQLite command:



DELETE FROM t1027 INNER JOIN translationsmain ON t1027.textid=translationsmain.textid WHERE translationsmain.osb=0


The column "textid" exists both in the table "t1027" and in "translationsmain". The column "osb" only exists in "translationsmain".


I am getting a syntax error, but I am not sure why.


Aucun commentaire:

Enregistrer un commentaire