MySQL update query involving two tables is not working, ...really stumped!
i'm really stumped why this SQL statement is not working. I guess my MySQL has gotten rusty.
The error i'm getting is this.
UPDATE mscanproducts SET mscanproducts.manufacturers_id = 37 where
mscanproducts.products_id = mscanproducts_to_categories.products_id and mscanproducts_to_categories.categories_id = 5;
but i'm sure the column and table do exist
Unknown column 'mscanproducts_to_categories.products_id' in 'where clause'
i'll try to briefly to describe the tables
products_id | manufactures_id
1 | null
products_id | categories_id
1 | 5