Sql Query To Add Products To A Different Category By Manufacturer

[EJ Agencia]

Hi there!

We are trying to sort out an SQL Query in order to do the following:

• Select Products from 1 manufacturer;
• Assign a second category to the selected products (without change default category).

 

The following query doesn't work:

 

UPDATE ps_category_product SET id_category = 57 WHERE id_manufacturer = 20

 

Thanks for your help!