Update a column based on a field from another table
- by Sergio
Hi:
I'd like to update values in one table based on corresponding values from other tables. Say you want to update prices of pieces provided by one specific manufacturer whose name is in the table Manufacturers with the Pieces table containing only the id of the manufacturer.
I've seen several solutions for MySQL here and for MS SQL Server here but none of them seems to work in SQLite.
Any suggestion?