How would I do this with an sql query?

[member]

I basically need the data in the products description table but I want the corresponding category ID in this output also.





I am trying to use the product name, product description and product short description to pull the relevant keywords from so I can use it to populate meta_tags_categories_description.

I will then either insert the meta information through phpmyadmin, or insert it via an sql statement if anyone can tell me how I might be able to do that.

I tried learning sql today, but I think it would take days or weeks or? to fiqure out what should be a couple of simple statements.

If anyone could help that would really be great. I have a lot of linked products, if that makes a difference.






This is unrelated (but I will share) to find and replace things in phpmyadmin you can use the following statement and replace the relevant tables and fields.
Backup your database first!! I can see how powerful sql is from the hours this saves. That is why I am trying to figure out how to get what I need it the above question.

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");

I would quote where I found this, but it might not be acceptable to do so in the forum??


Thanks for any help.

[solarflare]

You're looking for JOIN commands.

[member]

Is there any way you could give an example?

Thanks