多表关联的delete和update语句语法

表zhu为主表，表cong为从表

delete from cong
from cong left join zhu on cong.mid=zhu.id
where zhu.name='jeney'

update cong set mxname='aa'
from  cong
left join zhu on cong.mid=zhu.id  --and zhu.name='jeney'
where zhu.name='jeney'