DELETE FROM tab_stk_rawstock_rollsWHERE rollid IN (SELECT dbo.tab_stk_rawstock_rolls.rollid FROM dbo.tab_stk_rawstock_rolls INNER JOIN dbo.tab_stk_rawstock_adjustmentsrolls ON dbo.tab_stk_rawstock_rolls.rollid = dbo.tab_stk_rawstock_adjustmentsrolls.roll_id INNER JOIN dbo.tab_arc_gritems ON dbo.tab_stk_rawstock_rolls.grn_item_id = dbo.tab_arc_gritems.ITEM_ID INNER JOIN dbo.tab_stk_purchase_items ON dbo.tab_arc_gritems.PURCHASE_ITEM_ID = dbo.tab_stk_purchase_items.ITEM_ID WHERE (dbo.tab_stk_rawstock_rolls.qty - dbo.tab_stk_rawstock_adjustmentsrolls.adjustment_quantity = 0) AND (dbo.tab_stk_purchase_items.RAW_STOCK_REF = '')); DELETE FROM tab_stk_rawstock_adjustmentsrolls WHERE roll_adjustment_id IN (SELECT dbo.tab_stk_rawstock_adjustmentsrolls.roll_adjustment_id FROM dbo.tab_stk_rawstock_rolls INNER JOIN dbo.tab_stk_rawstock_adjustmentsrolls ON dbo.tab_stk_rawstock_rolls.rollid = dbo.tab_stk_rawstock_adjustmentsrolls.roll_id INNER JOIN dbo.tab_stk_gritems ON dbo.tab_stk_rawstock_rolls.grn_item_id = dbo.tab_stk_gritems.ITEM_ID INNER JOIN dbo.tab_stk_purchase_items ON dbo.tab_stk_gritems.PURCHASE_ITEM_ID = dbo.tab_stk_purchase_items.ITEM_ID WHERE (dbo.tab_stk_rawstock_rolls.qty - dbo.tab_stk_rawstock_adjustmentsrolls.adjustment_quantity = 0) AND (dbo.tab_stk_purchase_items.RAW_STOCK_REF = ''))