Update Join Sql

update `hipdata` h right join pttype_bb pb on h.cid=pb.`3420900078775` set moi_status="OFC",pttype='26' ;