How can you UPDATE a table without using UPDATE? (Select 2)
By Using a Self Join.
By Using a Nested Join.
By using a Volatile Temporary Table.
By using a View.