Skip navigation links

MySQL Forums :: Newbie :: double join in update?


Advanced Search

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? Yakymenko Serhiy 06/28/2012 04:09PM
Re: double join in update? Peter Brawley 06/28/2012 04:35PM
Re: double join in update? Yakymenko Serhiy 06/28/2012 04:46PM
Re: double join in update? Peter Brawley 06/28/2012 09:48PM
Re: double join in update? Yakymenko Serhiy 06/29/2012 01:09AM
Re: double join in update? Peter Brawley 06/29/2012 06:46AM
Re: double join in update? Yakymenko Serhiy 06/29/2012 01:34PM
Re: double join in update? Rick James 07/01/2012 08:25PM
Re: double join in update? Yakymenko Serhiy 07/04/2012 10:37AM


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.