How to write an SQL query to update a table based of a result in another table : I have 2 different tables in my datbase and cant find any refrence on how to use a reuslt to update a part of a table.

Here is my scenario
    
    Table: MenuItems
    ╔════╦══════════════╦
    ║ id ║  Name        ║
    ╠════╬══════════════╬
    ║  1 ║ test         ║
    ║  2 ║ test2        ║
    ╚════╩══════════════╩
    
    Table: MenuItemPrices
    ╔════╦══════════════╦
    ║ id ║  Price       ║
    ╠════╬══════════════╬
    ║  1 ║ 3.50         ║
    ║  2 ║ 4.50         ║
    ╚════╩══════════════╩


Say I want to update test2 price to 5.00, what would be the query I need?