UPDATE BILL_ITEM_DETAIL SET HSNCODE = '998821'


UPDATE BILL_ITEM_DETAIL SET HSNCODE = '998821' WHERE BillNo IN (SELECT BILLNO FROM BILL_DETAIL WHERE SaleType = 'SALEA/C')