UPDATE JOIN
Версия 3.1 от Alexandr Fokin на 2020/08/06 10:08
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>