SQL Server - Update statement with FROM clause with multi joins

Asked By anbu n on 03-Sep-13 11:21 AM
how the sql Update statement work , while using FROM Clause with multiple joins[also in this situation how the WHERE clause work] ?,
 
also is it necessary that the table which is getting updated has to be in FROM clause ?
 
kindly explain
Robbe Morris replied to anbu n on 03-Sep-13 01:44 PM
The update statement works on only one table at a time.  Post your sql, perhaps we can help you with the other stuff.
anbu n replied to Robbe Morris on 15-Sep-13 07:49 PM
also is it necessary that the table which is getting updated has to be in FROM clause ?