Hello experts,
I have an sql update statement where I update the stock by summing up the available stock in the warehouse, the query looks like the following:
UPDATE managed_material_x
SET managed_material_x.[Rack Quant] = (SELECT stock_rack_x_quant.[Rack Stock] FROM stock_rack_x_quant WHERE managed_material_x.Material=stock_rack_x_quant.Material);
I am runninng this query from MS Access 2003 to update the tables on MySQL server 5.0, but it always give me the error "Operation must be an updeatable query." error.
Thanks in advance
By the way, I am running everything on Windows XP box.
I have an sql update statement where I update the stock by summing up the available stock in the warehouse, the query looks like the following:
UPDATE managed_material_x
SET managed_material_x.[Rack Quant] = (SELECT stock_rack_x_quant.[Rack Stock] FROM stock_rack_x_quant WHERE managed_material_x.Material=stock_rack_x_quant.Material);
I am runninng this query from MS Access 2003 to update the tables on MySQL server 5.0, but it always give me the error "Operation must be an updeatable query." error.
Thanks in advance
By the way, I am running everything on Windows XP box.