joins represents table sources in following clauses of SQL statement:
from clause of select statement.
from clause of delete statement, Specifies an additional FROM clause, This Transact-SQL extension to DELETE allows specifying data from table_source and deleting the corresponding rows from the table in the first FROM clause.
from clause of update statement, Specifies that a table, view, or derived table source is used to provide the criteria for the update operation.