I am using a shopping cart and have entered over 700 products and now find out that I am missing one important field and rather than go through the frontend I would like to run a SQL statement to make add the info.
I have 2 tables...
The common field is productid......
There are only 2 fields in Product_Taxes - productid and taxid.
I updated 3 products manually through the frontend so I only have 3 entries in the Product_Taxes table.
What I think I need to do is be able to join the two tables using productid and enter taxid from an update statement.....but I am not sure how to do it.