I have two tables called ata and sku and i want to match SKU from ata table and ARTIKEL_NUMBER from sku table to fit weight from ATA (TOTAL_WEIGHT_PIECE) on sku column called Greutate_kg.
CodePudding user response:
You can try next:
UPDATE sku
JOIN ata ON ata.ARTIKEL_NUMBER = sku.SKU
SET sku.Greutate_kg = ata. TOTAL_WEIGHT_PIECE
WHERE sku.Greutate_kg IS NULL;