update a field drom another table

[cemal]

hi guys.

I have two table ; categories and products
categories table; catid (int) catname, and products table has
catid(int), catname

I want to update products.catid= catgory.catid where
category.catnam e=products.catn ame

never mind please, as soon as I started writing my message I figured
it out.

UPDATE Products
SET catid = Categories.Cate goryID
FROM Products INNER JOIN
Categories ON Products.Catego ryID =
Categories.Cate goryName

this sql command solved my issue.

thank you all for creating an option to get help.

Cemal
Milwaukee