mkx

I have 3 mysql tables

table1 =
orderid,shippingmethod

table2 =
transactionid,orderid

table3 =
transactionid,shipmethod2

I want to update all of table 1's shippingmethod to show the shipmethod2 from table 3

Can anyone post the code to do this? I am getting a bit confused