UPDATE JOIN
Версия 1.1 от Alexandr Fokin на 2020/08/06 10:01
UPDATE <aliasName>
SET
FROM <tableName> <aliasName>
JOIN
(
...
) as joinAlias
ON aliasName.id = joinAlias.id
JOIN
(
...
) as joinAlias2
ON aliasName.id = joinAlias2.id
WHERE
aliasName.id = <id>
SET
FROM <tableName> <aliasName>
JOIN
(
...
) as joinAlias
ON aliasName.id = joinAlias.id
JOIN
(
...
) as joinAlias2
ON aliasName.id = joinAlias2.id
WHERE
aliasName.id = <id>