Hi,
(this isn’t correct code i know, im just getting my point across)
Here’s my problem.
I want to update the “stock quantity” in my table “products” e.g
UPDATE “products” SET “stock quantity”=X WHERE “part number”=X
The difficulty however is that the stock quantity and part number aren’t in the same table
instead the products table looks like product ID , stock quantity
and then i have another table product name which looks like product ID , part number etc.
So if I havent made it clear enough, i need to update the products table with the stock quantity but in order to do so use the part number to get the correct Product ID in the product name table to enable me to update the stock quantity !
Argh :
can someone let me know if this is possible please,
thanks, Carl.