Update each row in the table based on results
Posted on 2011-10-20
I have a DataTable of my customers orders with one empty column. My columns:
ID_Name is the empty column. I am getting values for this column from another table, called products, which has ID's and names of each product:
ID_PROD is a foreign key for customers table (ID column).
How to update ID_Name column from customers table? I wanna get ID_Name_prod for each row in the customers table and update that row, which is initially empty.
I am selecting ID_Name_prod with the query:
FROM customers LEFT JOIN products
ON customers.ID = products.ID_Name_prod
This query returns column with all the products names - but how to update each row in my customers table?