update + join 多表操作 

UPDATE vtiger_notificationcf as a INNER JOIN vtiger_crmentity as b
ON a.notificationid = b.crmid
SET a.isread = '已读'
WHERE
	b.smownerid = '495'

 

posted @ 2018-06-25 10:19  安筱雨  阅读(6520)  评论(0)  编辑  收藏  举报