1924
правки
Изменения
Нет описания правки
Query update address a join
(select b.address, sum(b.kol_vo*b.price) as price, sum(b.kol_vo*b.mass) as mass, sum(b.kol_vo) as kol_vo
from address a join boxes b on b.address=a.code where a.zakaz=%zakaz% group by b.address) b on a.code=b.address
set
a.kol_vo=b.kol_vo,