Update multiple table column values using single query in SQL?

I have two tables like Temp1 and Temp2

The Table Temp1 have id and Col1 fields and The Table T开发者_开发问答emp2 have id and Col2 fields

I need to update the two table fields Col1 and Col2 using single query in SQL.

Can anyone help me??????

---

You can't update 2 tables in single SQL. Use stored procedure or transaction