UPDATE JOIN
Версия 3.4 от Alexandr Fokin на 2021/10/25 11:26
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>