SELECT     dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.PACKINGID, dbo.PACKING.SALESINVOICEID, 
                      dbo.PACKING.Destination, dbo.SalesInvoice.SalesInvoiceNO, dbo.SalesInvoice.ORDERVALUE, dbo.PACKING.PlaceofReceipt, 
                      dbo.PACKING.PortofDischarge, dbo.PACKING.PlaceofDelivery, dbo.PACKING.DescriptionOfGoods, dbo.PACKING.PortofLoading, 
                      dbo.PACKING.Vessel_FlightNO, dbo.PACKING.GrossWeight, dbo.PACKINGDET.Description, dbo.PACKINGDET.BoxesQty, 
                      dbo.PACKINGDET.ContainerNO, dbo.SalesInvoice.SalesInvoiceDATE, dbo.PACKINGDET.NO_Kind_Pkgs, dbo.PACKING.NetWeight, 
                      dbo.PACKING.CurrencyOfInvoice, dbo.SalesInvoice.FREIGHT, dbo.CUSTOMER.CUSTOMERNAME, dbo.CUSTOMER.ECC_NO, 
                      dbo.INCOTERMS.TRADETERMS, dbo.PAYMENTTYPE.PAYMENTTYPE, dbo.DISCOUNTDET.DISCOUNTPERC, dbo.SALESINVTOTALVALUE.Expr1 AS Total,
                       dbo.SALESORDER.PODATE, dbo.SALESORDER.PONUMBER, dbo.SALESORDER.CONSIGNEDTO, dbo.CUSTOMER.CUSTOMERID, 
                      dbo.CUSTOMER.ADDRESS1, dbo.CUSTOMER.ADDRESS2, dbo.CUSTOMER.ADDRESS3, dbo.CUSTOMER.SOLDTO, dbo.CUSTOMER.SHIPTO
FROM         dbo.CUSTOMER INNER JOIN
                      dbo.SALESORDER ON dbo.CUSTOMER.CUSTOMERID = dbo.SALESORDER.CUSTOMERID INNER JOIN
                      dbo.INCOTERMS ON dbo.CUSTOMER.INCOTERMSID = dbo.INCOTERMS.INCOTERMSID INNER JOIN
                      dbo.PAYMENTTYPE ON dbo.CUSTOMER.PAYMENTTYPEID = dbo.PAYMENTTYPE.PAYMENTTYPEID INNER JOIN
                      dbo.DISCOUNT ON dbo.SALESORDER.DISCOUNTID = dbo.DISCOUNT.DISCOUNTID INNER JOIN
                      dbo.DISCOUNTDET ON dbo.DISCOUNT.DISCOUNTID = dbo.DISCOUNTDET.DISCOUNTID CROSS JOIN
                      dbo.SALESINVTOTALVALUE INNER JOIN
                      dbo.PACKING INNER JOIN
                      dbo.SalesInvoice ON dbo.PACKING.SALESINVOICEID = dbo.SalesInvoice.SalesInvoiceID INNER JOIN
                      dbo.PACKINGDET ON dbo.PACKING.PACKINGID = dbo.PACKINGDET.PACKINGID INNER JOIN
                      dbo.SODISPATCH ON dbo.SalesInvoice.SODISPATCHID = dbo.SODISPATCH.SODISPATCHID ON 
                      dbo.SALESINVTOTALVALUE.SalesInvoiceID = dbo.SalesInvoice.SalesInvoiceID