Hello Everyone,
I am trying to update one table called categories, the column catagories_image from the table called catagories_description where the column catagories_name is "something"
Basicly, I have named a catagory something, and an image the same thing, Based on the catagory name, I need the field "catagories_image" to change based on the catagories name
Here is the code I have that is not working, I have done alot of searching and see alot about JOIN and such, but am not sure its what i need
update categories
set categories_image = 'accessories.jpg'
from categories_description
WHERE categories_name like 'Accessories'
As you can see. Any field with the name accessories in the table categories_description, I want the catagories_image in the table catagories to change to accessories.jpg.
I did it in the same table based on the catagories_id, but there are over 100, different numbers. And it would take forever to put them all in a single statement. And there are over 50 total catagories I will need to do this to.
If anyone could help out, It would really help me out!!
Thanks in advance, and I really appreciate it!
Dan Termani
http://TermaniMotorsports.com