A
Anonymous
Guest
You must be using mysql 4.0.4 or greater to accomplish this in one query.
wait a minute if products.cat is your description how can it be your id also need to change the end products.cat to your foreign key (products.cat_id)
Code:
UPDATE products,cat2 SET products.cat = cat2.cat_desc WHERE cat2.id = products.catwait a minute if products.cat is your description how can it be your id also need to change the end products.cat to your foreign key (products.cat_id)