UPDATE QUERY

[Elizabeth Alderton]

Can anyone give me a pointer as to whether an update query, similar to below, is 
possible - and if so how?

(I've put it in caps since that's the way it is typed in mysql)

UPDATE SUBCATEGORY 
SET CATID=CATEGORY.CATID
WHERE
SUBCATEGORY.ORGID=CATEGORY.ORGID
 
SUBCATEGORY and CATEGORY are table names


Thanks in advance!

Regards

Elizabeth