mysql - Update Two Tables -error - Unknown column 'product_varities.product_varities_id' in 'where clause' -

i trying update 2 tables, taking data 1 table , updating second table. keep getting error:

1054 - unknown column exception in mysql.

orderlines orderlinesid quantity product_varities_id (fk)  product varities product_varities_id (pk) quantity 

stored proc:

begin declare quantitytoaddback int(5);  select orderlines.quantity orderlines orderlines.order_id = iorderid , product_varities.product_varities_id = iproductvaritiesid quantitytoaddback; -- update first update orderlines set orderlines.`status_id` = 2 orderlines.order_id = iorderid , orderlines.product_varities_id = iproductvaritiesid;  -- update quantity update product_varities set product_varities.quantity = product_varities.quantity + quantitytoaddback product_varities.product_varities_id = iproductvaritiesid;  end 

i don't understand doing wrong, executing 2 statements because research on here found cannot update 2 tables @ once.

from given description looks iorderid , iproductvaritiesid input values procedure.

so queries inside procedure should as

select  ol.quantity quantitytoaddback orderlines ol join product_varities pv on pv.product_varities_id = ol.product_varities_id ol.order_id = iorderid ;  -- update first update orderlines set `status_id` = 2 order_id = iorderid  , product_varities_id = iproductvaritiesid;   -- update quantity update  product_varities  set quantity = quantity + quantitytoaddback product_varities_id = iproductvaritiesid;