Comersus Version: 705
Database type: Access
Frequency: Random issue
hi, i'm trying to do an update through the genericSQL script, but i'm a bit confused, i need to update the category that some products are in depending on the name.
this is waht i've got so far:
UPDATE categories_products, products
SET categories_products.idCategory = 196
WHERE products.description LIKE '%polo%'
will this work?