MySQL Forums
Forum List  »  Newbie

double join in update?
Posted by: Yakymenko Serhiy
Date: June 28, 2012 04:09PM

Hello everyone,
have a brain task, cant get in, need help.

have 3 table with next fields:

category_id category_name

product_id category_id

product_id product_name agregate_field

Need update `products` and set every

Is it possible in 1 query?

Have a practice with subqueries but with no success.
have no practice with joins.
Thanks in advance.

Options: ReplyQuote

Written By
double join in update?
June 28, 2012 04:09PM
July 01, 2012 08:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.