I'm sure I'm a moron and its a simple fix, but basically...
I have two tables
new item/price table (z_prc) that contains item# and price
and an old products table
I want to update the prices in the products table based on the price from the new z_prc table based on item number.
whats the best way to do something like that?
