[CLUE-Tech] MySQL 3.23

[David Willson]

I need to UPDATE a field in one table with the corresponding information in another table.
I have two tables:
Products (
  Id integer,
  Price decimal(6,2)
  )
and
New_Prices (
  Id integer,
  Price decimal(6,2)
  )

I need to use the New_Prices.Price to overwrite the Products.Price.  How do I do it?  Anyone?  Anyone?  As an additional motivator, this is ~easy~ in PostgreSQL.  Actually, I'm certain this is easy, and I'm just missing it...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-tech/attachments/20040420/f940caa3/attachment.html