ItemCode Qty Harga AAA 10 100.000 AAA 10 150.000 AAA 10 200.000
ItemCode Qty Harga AAA 10 100.000 AAA 0 150.000 AAA 0 200.000
UPDATE MyTable SET Qty=0 WHERE ItemCode='AAA' AND Harga!=100
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)