问题描述:进行update某个表数据的时候,需要关联查询若干表进行筛选过滤.
问题解决:
UPDATE t_order_third AS t
INNER JOIN t_order_attachment AS s ON s.forderId = t.fthirdchildId
SET t.fuserstate = 5,
t.fuser2state = 24,
t.fupdated = now(),
t.ffinished = now()
WHERE
s.fattachmentType = 'receipt'
AND datediff(curdate(), s.fcreated) = 10
AND t.fuser2state = 33
AND t.fuserstate = 41;
注意:红色字体处是更新语句主体部分,而绿色字体主要是进行关联查询,以及查询过滤条件.
参考:http://blog.sina.com.cn/s/blog_4c197d420101aer2.html