How can I update table by using select statement in SQLite

sql, sqlite

Solution

I think either of the following will work:

UPDATE  tbl_1 
SET     field1 = 6, field12 = NULL 
WHERE   EXISTS 
        (   SELECT 1
            FROM tbl_2 
            WHERE tbl_1.field3 = tbl_2.item1 
            AND tbl_2.item2 = 135
        )

OR

UPDATE  tbl_1 
SET     field1 = 6, field12 = NULL 
WHERE   field3 IN (SELECT item1 FROM tbl_2 WHERE item2 = 135)

Problem

I want to update one table with the help of the foreign key of others table. I am trying to do something like this: ``` UPDATE tbl_1 SET field1 = 6, field12 = NULL WHERE field3 = (SELECT tbl_2.item1 FROM tbl_1, tbl_2 WHERE tbl_1.field3 = tbl_2.item1 AND tbl_2.item2 = 135) ``` OR ``` UPDATE tbl_1 SET field1 = 6, field12 = NULL WHERE field3 = (SELECT item1 FROM tbl_2 WHERE item2 = 135) ```

Original source