just like "update a set a.temp=b.temp from table1 a inner join table2 b on a.ID=b.ID"

or "update user u left join userInfo i on u.uid = i.userId set u.name = 'chen' where u.uid = 1"

Also with delete

jsqlparser useful to me to help group