Sqlite3 update select

UPDATE 
      software
SET purchprice = (SELECT purchprice
                  FROM softwarecost
                  WHERE id = software.id) 
where EXISTS (SELECT purchprice
                  FROM softwarecost
                  WHERE id = software.id)

Source: stackoverflow.com

Similar codes

0 vote154 views1 answer
Grant owner postgresql
SQL
2 votes167 views1 answer
Coalesce sql
SQL
0 vote171 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote200 views1 answer
Sql comment header
SQL
123 votes928 views5 answers
Sql where contains
SQL
0 vote157 views1 answer
How to locate pg_hba.conf file
SQL
0 vote152 views1 answer
Linebreak sql
SQL
5 votes147 views1 answer
How to check nls format in oracle
SQL
0 vote150 views1 answer
List in one column mysql
SQL
0 vote143 views1 answer
Drop constraint in ms sql
SQL