UPDATE
A AS fcc
INNER JOIN
(
SELECT tf.*
FROM B AS ords
LEFT JOIN C AS tf
ON (ords.a = tf.a)
LEFT JOIN D AS fcc
ON (fcc.a = tf.a)
) AS a
SET
fcc.a = a.a
转载于:https://my.oschina.net/u/1260823/blog/692365
UPDATE
A AS fcc
INNER JOIN
(
SELECT tf.*
FROM B AS ords
LEFT JOIN C AS tf
ON (ords.a = tf.a)
LEFT JOIN D AS fcc
ON (fcc.a = tf.a)
) AS a
SET
fcc.a = a.a
转载于:https://my.oschina.net/u/1260823/blog/692365