UPDATE vtiger_notificationcf as a INNER JOIN vtiger_crmentity as b
ON a.notificationid = b.crmid
SET a.isread = '已读'
WHERE
b.smownerid = '495'
UPDATE vtiger_notificationcf as a INNER JOIN vtiger_crmentity as b
ON a.notificationid = b.crmid
SET a.isread = '已读'
WHERE
b.smownerid = '495'
转载于:https://www.cnblogs.com/anxiaoyu/p/9223091.html