sql - Update a column based on a field from another table -

I want to update prices in a table based on values ​​related to other tables. It is said that you want to update the prices of pieces provided by a specific manufacturer, whose name is table with the manufacturer's ID in the table manufacturer to pieces table.

I have seen many solutions for MySQL and MS SQL Server but none of them is working in SQLite.

Any suggestions?

updated pieces SET value = 42 where manufacturer_ID = (manufacturers select ID where name = 'FooBar Inc.')