shouldn't this work in ANSI SQL?

[sfullman]

This looks like it should work to me

(I have a new table called categories with a category and a subcategory. I assigned a primary key called ID to it. I have already "pulled these values out" of a table called products, and added a foreign key field called category_ID.

I want to assign the corresponding primary key value into the foreign key field)

UPDATE products set
products.Category_ID = categories.ID
WHERE
products.Category = categories.Category AND
products.SubCategory = categories.SubCategory

Thank you for your help,
Sam Fullman
Compass Point Media

[ultraslacker]

That will not work with mysql - are you using oracle?

[sfullman]

I actually got it to work using mysql no less (most recent version),

I just added the other table name so it was recognized

UPDATE
categories,
products
set
products.Category_ID = categories.ID
WHERE
products.Category = categories.Category AND
products.SubCategory = categories.SubCategory

Nothing is actually updated in categories, of course. This is great, it will sure help when I'm pulling data from one tabel to another.

Sam