ANSI joins support in UPDATE & DELETE statement
SQL DW does not support to usual way of joins (ANSI) in UPDATE, DELETE statement. This makes difficult in case of table data modification. Though there is a workaround provided for CTAS this seems to be a lengthy process of data modification. Please have this feature available in SQL DW.
This feature is now available in the May release of Azure Synapse Analytics (formerly Azure SQL DW).
Writing complex update/delete statements without this is counter to habits formed from other databases. Result is slower than desired dev throughout sometimes.
Mohammad Najmuddin commented
Please let us know when you have this feature. This is very important when you are merging old and new sets of rows.
Multiple or Nested Joins of tables in UPDATE and DELETE statments