I have two tables:
1) products_category
-cat_id
-cat_name
2) related_category
-rel_cat_id (exaclty same as products_category.cat_id==related_category.rel_cat_id)
-rel_cat_name
products_category table

related_category table

I want to get cat_name from products_category and want to store in rel_cat_name in related_category tabel. and the query should be only one.
Not sure how will it works.
I thought it would be something like:
Code: Select all
UPDATE related_category
SET related_category.rel_cat_name =
(
SELECT product_category.cat_name FROM product_category
INNER JOIN related_category
ON related_category.rel_cat_id = product_category.cat_id
)Please assist. Thanks in advance