Posted by cemal on 03/11/07 22:09

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.catname=products.catname

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

UPDATE Products
SET catid = Categories.CategoryID
FROM Products INNER JOIN
Categories ON Products.CategoryID =
Categories.CategoryName

this sql command solved my issue.

thank you all for creating an option to get help.

Cemal
Milwaukee

[Back to original message]