UPDATE pdx_mz.review_info as revinf join pdx_mz.prodapplications as pa on  revinf.prod_app_id=pa.id 
SET revinf.recomendType=NULL, revinf.reviewStatus='ASSIGNED' 
where revinf.reviewStatus like 'SUBMITTED' 
and pa.regState like 'REVIEW_BOARD';