Re: Problem with Nested Inserts

[Juan Javaloyes]

I solved my problem. Saw on other forums this solution (for oracle):

update prod_suc ps set (cantidad, stockini, precio_may1, precio_may2) =
(select stock, stock, preciom, preciom2 from prod_cant pc where ps.cod_prod = pc.codigo);

That solution didn't work for me in MySQL, there seems to be a problem with grouping updates on MySQL, so I did it manually for each row:

UPDATE prod_suc ps
SET cantidad = (SELECT stock FROM prod_cant pc WHERE ps.cod_prod = pc.codigo)

and so on for the rest of the rows... There's another way, or IS there a TO DO for MySQL?