6 lines
280 B
MySQL
6 lines
280 B
MySQL
|
-- recorrer los inventarios y verificar que no tengan el campo sticker > 0 en caso contrario regularizar a zero
|
||
|
|
UPDATE vn.buy b
|
||
|
|
JOIN vn.entry e ON e.id = b.entryFk
|
||
|
|
JOIN vn.entryConfig ec ON ec.inventorySupplierFk = e.supplierFk
|
||
|
|
SET printedStickers = 0
|
||
|
|
WHERE printedStickers <> 0;
|