Comments
-
You will UPDATE with a JOIN to a table for JOINs based on a SELECT. https://www.mysqltutorial.org/mysql-update-join/ UPDATE T1, T2, [INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1 SET T1.C2 = T2.C2, T2.C3 = expr WHERE condition You can also reach out to your Customer Success Manager, they will be able to get some in-depth…
