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:

`categories`:
category_id category_name

`product_categories`:
product_id category_id

`products`:
product_id product_name agregate_field


Need update `products` and set every
agregate_field=concat(category_name,product_name).

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


Subject
Written By
Posted
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.