* The LOADING data is already filtered before it gets here. SELECT ; PRDPIFIL.X1 AS Three_Fours, ; PADR(Loading.ProdCode, 15, "") AS Product_Code, ; "01" AS Zero_One, ; SUM(RIGHT(STR(Loading.Net),6)) AS Net_Weight, ; PRDPIFIL.UM AS Unit, ; SPACE(1) AS FILLER_1, ; LEFT(Loading.Order, 6) AS Order_Number, ; SPACE(8) AS FILLER_2, ; PRDPIFIL.LOCN AS Location, ; SPACE(9) AS FILLER_3, ; Loading.Cust AS Customer, ; SPACE(9) AS FILLER_4, ; ThisForm.dShip AS cShipped_Date, ; SPACE(7) AS FILLER_5, ; ThisForm.BatchNo AS Batch_Number, ; "IRL-PP" AS IRL_FILLER, ; SPACE(4) AS FILLER_6, ; ThisForm.ShippingUploadDate AS cShipUpload_Date, ; ThisForm.ShippingUploadTime AS cShipUpload_Time ; FROM ; LOADING, ; PRDPIFIL ; WHERE ; ALLTRIM(LOADING.ProdCode)==ALLTRIM(PRDPIFIL.PN) ; GROUP BY ; LOADING.Order + LOADING.Line, ; Three_Fours, ; Product_Code, ; Zero_One, ; Unit, ; FILLER_1, ; Order_Number, ; FILLER_2, ; Location, ; FILLER_3, ; Customer, ; FILLER_4, ; cShipped_Date, ; FILLER_5, ; Batch_Number, ; IRL_FILLER, ; FILLER_6, ; cShipUpload_Date, ; cShipUpload_Time ; INTO TABLE E:\IRL\tmpShippedItems