SQL help

[Blackguard]

I don't know if this is a good place to post such a question, but if so, here we go!

I need to do somthing like this -

UPDATE products SET product_is_always_free_shipping = '1' WHERE products.products_id = products_to_categories.products_id AND products_to_categories.categories_id = 103

I don't know how to perform a join on an update query, and this is not working, telling me

#1109 - Unknown table 'products_to_categories' in where clause

But that table exists, hence my sql fu is not strong...

[Blackguard]

OK - I found my problem (need to include all table names after UPDATE).

My question now is

What is the syntax to update multiple categories at once?

UPDATE products, products_to_categories SET products.product_is_always_free_shipping = '1' WHERE products.products_id = products_to_categories.products_id AND products_to_categories.categories_id = ********LOTS OF CATEGORIES***********