DELETE [target table] FROM [table1] INNER JOIN [table2] ON [table1.[joining column] = [table2].[joining column] WHERE [condition]
UPDATE [target table] SET [target column] = [new value] FROM [table1] INNER JOIN [table2] ON [table1.[joining column] = [table2].[joining column] WHERE [condition]