php innerjoin question

[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

[sarettah]

Originally Posted by 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

update table_1 a inner join table_2 b on a.orderid=b.orderid inner join table_3 c on b.transactionid=c.transactionid set a.shippingmethod=c.shipmethod2

Should do it.

.

[mkx]

thanks ill give that a whirl