use T202223 INSERT INTO PURCHASE_ITEM_DETAIL SELECT VouNo, 'SAREE', 0, 0, 0, 'P', 0, VouNetAmt, CompCode, '', 0, '', 0, 0, 1, 0 FROM PURCHASE_DETAIL WHERE VOUNO NOT IN (SELECT VOUNO FROM PURCHASE_ITEM_DETAIL)
use T202223 INSERT INTO PURCHASE_ITEM_DETAIL SELECT VouNo, 'SAREE', 0, 0, 0, 'P', 0, VouNetAmt, CompCode, '', 0, '', 0, 0, 1, 0 FROM PURCHASE_DETAIL WHERE VOUNO NOT IN (SELECT VOUNO FROM PURCHASE_ITEM_DETAIL)