Kod: Tümünü seç
UPDATE LG_001_ITEMS SET
SALEDEDUCTPART1=7,
SALEDEDUCTPART2=10,
PURCDEDUCTPART1=7,
PURCDEDUCTPART2=10,
DEDUCTCODE='609',
PURCHDEDUCTCODE='209',
CANDEDUCT=1
WHERE CARDTYPE=1
AND CANDEDUCT=0
Kod: Tümünü seç
UPDATE LG_001_ITEMS SET
SALEDEDUCTPART1=7,
SALEDEDUCTPART2=10,
PURCDEDUCTPART1=7,
PURCDEDUCTPART2=10,
DEDUCTCODE='609',
PURCHDEDUCTCODE='209',
CANDEDUCT=1
WHERE CARDTYPE=1
AND CANDEDUCT=0