Update with Join in SQLite

by

This will work 

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

Here we use exists because
without that the query will set software.purchprice to null if no “correlated” row is found.

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I make an UPDATE while joining tables on SQLite?
  3. How do I rename a column in a SQLite database table?
  4. How do I check in SQLite whether a table exists?
  5. How to set Sqlite3 to be case insensitive when string comparing?
  6. Escape single quote character for use in an SQLite query
  7. Difference between 2 dates in SQLite
  8. Select random row from a sqlite table
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. Sqlite primary key on multiple columns
  12. Store boolean value in SQLite
  13. Can SQLite support multiple users?
  14. SQLite add Primary Key
  15. How delete table inner join with other table in Sqlite?
  16. Export from sqlite to csv using shell script
  17. SQLite: How do I save the result of a query as a CSV file?
  18. Create table in SQLite only if it doesn’t exist already
  19. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  20. How do DATETIME values work in SQLite?
  21. SQLite table constraint – unique on multiple columns
  22. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  23. Is there a boolean literal in SQLite?
  24. sqlite get ROWID
  25. How to have an automatic timestamp in SQLite?
  26. How to display blob value using x’abc’ binary string literal syntax?
  27. sql query – how to apply limit within group by
  28. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  29. Creating stored procedure in SQLite
  30. DbFunctions.TruncateTime LINQ equivalent in EF CORE

Leave a Comment