Update a single table based on data from multiple tables SQL Server 2005,2008

Question

I want to update data from one table to another table with year condition.
(OR)
To Update one table based on another table using INNER JOIN

Answer 1

Try this code:

UPDATE T1
SET result = t2.results
FROM [table one] T1
INNER JOIN [table three] t3
 on t1.reg_id = t3.reg_id
INNER JOIN [table two] T2
 on t2.venue = t3.venue