hi friends,
how do i update two tables column in a single query?

i can update single table columns from multiple tables conditions,

eg: update table1 set table1.field1,table1.field2 from table2,table3
where table1.field1=table2.field1 and table2.field1=table3.field1


i want to update columns of different tables table1.field1 and table2.field2

how do i update two tables columns in a single query.