SQL Statement Error in Sqlite near"."

Question

I keep getting this error near ".": syntax error: for the following SQL statement in SQLLite. Trying to update the price in one table if its id exists in another table which would have the new price

UPDATE tbl_tempwork SET tbl_tempwork.tempwork_productwholesale = 
tbl_pricelevel.pricelevel_wholesale FROM tbl_pricelevel WHERE 
tbl_pricelevel.pricelevel_productid = tbl_tempwork.tempwork_productid

score 0 · Answer 1 · answered Jul 31 '17 at 05:31

SQLite does not have any sort of update join syntax. But you can proceed as you might with Oracle, and do the update using a correlated subquery on the tbl_pricelevel table.

UPDATE tbl_tempwork
SET tempwork_productwholesale = (SELECT pricelevel_wholesale
                                 FROM tbl_pricelevel
                                 WHERE pricelevel_productid =
                                       tbl_tempwork.tempwork_productid)

score -1 · Answer 2 · answered Jul 31 '17 at 05:33

-1

UPDATE tbl_tempwork SET tbl_tempwork.tempwork_productwholesale = tbl_pricelevel.pricelevel_wholesale 
where exists (select 1 FROM tbl_pricelevel WHERE tbl_pricelevel.pricelevel_productid = tbl_tempwork.tempwork_productid)

answered Jul 31 '17 at 05:33

yılmaz

1,818
13
15

SQL Statement Error in Sqlite near"."

2 Answers2