I've heard that update with join is not supported by SQL standard, and MySQL does support it. Any reason for the standard doesn't support it?
What about delete? I think both (update&delete -- or those have where substatement in my mind) should support join.
Asked
Active
Viewed 28 times
0
Yarco
- 763
- 9
- 18
-
Similar question here: https://stackoverflow.com/questions/1591496/is-delete-from-join-standard-sql , but no detailed reason. (Maybe sub query has good performance than join in some cases?) – Yarco Aug 24 '17 at 03:05
-
You can use merge statement in sql to updat/delete using join. – Hirav Sampat Aug 24 '17 at 03:35
-
SQL Server supports Update from Join – RoMEoMusTDiE Aug 24 '17 at 03:40
-
I see. What I mean here is if a lot of DBMS support `join`, why the standard does not include this? – Yarco Aug 24 '17 at 03:42
-
MySQL allows joins in UPDATEs, if that's what you mean – Strawberry Aug 24 '17 at 05:32
-
I mean the SQL standard seems not support that. – Yarco Aug 24 '17 at 08:18