Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Update field if it is in another table

Author  Topic  paul13 Starting Member 17 Posts Posted - 2001-09-11 : 18:50:54 This is likely an error in code I am on MySQL on Linux box I want to update the "instore" field of the products table if the product is in store #4. I tried: update products set products.instore = '4' where products.id = store4.id and I was told that table store4 is an unknown table. Anytime I try to add a from clause I get an error. any ideas? paul13