Update multiple table column values using single query in SQL??

Question

I have two tables like Temp1 and Temp2

The Table Temp1 have id and Col1 fields and The Table Temp2 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??????

Answer 1

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