USE T202223

INSERT INTO PURCHASE_TRANSPORT_DETAIL SELECT PURCHASE_DETAIL.VouNo, '' AS TransName, '' AS TransLRNo, 0 AS TransLRCase, PURCHASE_DETAIL.SuppBillDate, CUSTOMER_MASTER.CustCityName, PURCHASE_DETAIL.CompCode FROM PURCHASE_DETAIL INNER JOIN CUSTOMER_MASTER ON CUSTOMER_MASTER.CustCode = PURCHASE_DETAIL.VouCustCode  where purchase_detail.vouno not in (select vouno from purchase_transport_detail)