SQL update with 2 categories

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?

Tags:, ,
One Comment

Add a Comment

Your email address will not be published. Required fields are marked *