------MISSING TRANSPORT DETAIL IN PURCHASE
USE T202627
INSERT INTO PURCHASE_TRANSPORT_DETAIL SELECT PURCHASE_DETAIL.VouNo, '' AS Expr1, '' AS Expr2, 0 AS Expr3, PURCHASE_DETAIL.SuppBillDate, CUSTOMER_MASTER.CustCityName, PURCHASE_DETAIL.CompCode, 0 AS Expr4, 0 AS Expr5 FROM PURCHASE_DETAIL INNER JOIN CUSTOMER_MASTER ON PURCHASE_DETAIL.VouCustCode = CUSTOMER_MASTER.CustCode WHERE PURCHASE_DETAIL.VouNo NOT IN (SELECT VouNo FROM PURCHASE_TRANSPORT_DETAIL)