UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1
WHERE col_ID in (select col_id
from tbl_fruit
where col_id=2)