How would I do this with an sql query?

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.

You're looking for JOIN commands.

Is there any way you could give an example?

Thanks