Fusing records together

[breezett93]

I've got two records that need to be combined into one. Most of the data between the two is identical, but there are a couple fields that are not. The fields that have a 0 should be replaced by the non-zero numbers. Then I want "TIMB" replaced by whatever the other choice is/I never want TIMB chosen. There's probably a couple solutions here, but this query already takes too long to process; so I'm looking for the most efficient method.

Thanks

[ranman256]

query IS the best solution.
Q1 to pull a zero field on ID
Q2 to pull a Non zero value on ID
Q3 to update Q1 from Q2