Update table with entries from other table, with join
update table set field1 = other_table.field1, field2 = other_table.field2 from table inner join other_table on other_table.field3=table.field3
Wish list
If you like this blog and want to say thanks in some way, here is my wish-list on Amazon. It'll be very cool to get a gift from my subscribers. Just don't forget to put your name on it -)Tags