SELECT     dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.PACKINGID, dbo.PACKING.SALESINVOICEID, 
                      dbo.PACKING.Consignee, dbo.PACKING.ConsigneeCountry, dbo.PACKING.Destination, dbo.SalesInvoice.SalesInvoiceNO, dbo.PACKING.PlaceofReceipt, 
                      dbo.PACKING.PortofDischarge, dbo.PACKING.PlaceofDelivery, dbo.PACKING.DescriptionOfGoods, dbo.PACKING.PortofLoading, 
                      dbo.SalesInvoice.TOTAL AS Tot, 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.PACKINGDET.Marks_Nos, dbo.SALESORDER.EXCHRATE, 
                      dbo.CUSTOMER.CUSTOMERNAME, dbo.CUSTOMER.ADDRESS1, dbo.CUSTOMER.ADDRESS2, dbo.CUSTOMER.ADDRESS3, 
                      dbo.SALESINVTOTALVALUE.Expr1 AS Total
FROM         dbo.SODISPATCHDET INNER JOIN
                      dbo.SALESORDERDET INNER JOIN
                      dbo.SALESORDER ON dbo.SALESORDERDET.SALESORDERID = dbo.SALESORDER.SALESORDERID ON 
                      dbo.SODISPATCHDET.SALESORDERDETID = dbo.SALESORDERDET.SALESORDERDETID INNER JOIN
                      dbo.SODISPATCH 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.SalesInvoiceDET ON dbo.SalesInvoice.SalesInvoiceID = dbo.SalesInvoiceDET.SalesInvoiceID ON 
                      dbo.SODISPATCH.SODISPATCHID = dbo.SalesInvoice.SODISPATCHID ON 
                      dbo.SODISPATCHDET.SODISPATCHID = dbo.SODISPATCH.SODISPATCHID INNER JOIN
                      dbo.CUSTOMER ON dbo.SALESORDER.CUSTOMERID = dbo.CUSTOMER.CUSTOMERID INNER JOIN
                      dbo.SALESINVTOTALVALUE ON dbo.SalesInvoice.SalesInvoiceID = dbo.SALESINVTOTALVALUE.SalesInvoiceID