一条sql 更新两张表的数据

UPDATE

product
INNER JOIN
message
ON
product.ID = message.EnterpriseProductListID
SET
product.Status = 'S', message.Status = 'S'
WHERE
message.MessageID='881101_20150130102733436324'
AND

message.MessageType='881101';

更新三张表

UPDATE
( 
 listheader
 INNER JOIN 
 listdetail ON 
 listheader.ID=listdetail.ListheaderID
) 
 INNER JOIN 
 message ON 
 listheader.ID = message.EnterpriseProductListID
 SET
 listheader.Status = 'F',
 listdetail.Status = 'F',
 message.Status = 'F'
 WHERE
 listheader.ID = 20;