How can i update table by using select statement in sqllite
I want to update one table with the help of the foreign key of others table.
i am try to do like 

  
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)

How can i update table by using select statement in sqllite
===

I want to update one table with the help of the foreign key of others table.
i am try to do like 

  
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)
