SQL DELETE JOIN
This is very commonly asked question that how to delete or update rows using join clause
It is not a very easy process, sometimes, we need to update or delete records on the basis of complex WHERE clauses.
There are three tables which we use to operate on SQL syntax for DELETE JOIN.
These tables are table1, table2 and target table.
SQL Syntax for delete JOIN
Syntax for update