SELECT     dbo.SalesInvoice.SalesInvoiceNO, dbo.SalesInvoice.SalesInvoiceDATE, dbo.PACKINGDET.BoxesQty, dbo.PACKINGDET.PackedQty, 
                      dbo.PACKINGDET.NO_Kind_Pkgs, dbo.PACKINGDET.ContainerNO, dbo.PACKINGDET.Marks_Nos, dbo.PACKING.Consignee, 
                      dbo.PACKING.ConsigneeCountry, dbo.PACKING.NetWeight, dbo.PACKING.GrossWeight, dbo.PACKING.CurrencyOfInvoice, dbo.PACKING.RemovalTime, 
                      dbo.SalesInvoice.ORDERVALUE, dbo.PACKING.Remarks, dbo.SalesInvoiceDET.SalesInvoiceID, dbo.PACKING.PACKINGID, 
                      dbo.SalesInvoice.SODISPATCHID, dbo.TOTALINARE1.TOTAL AS EXTRA, dbo.TOTALINARE1.QTY, dbo.SALESINVTOTALVALUE.Expr1 AS TOTAL, 
                      dbo.SalesInvoice.EXCHRATE
FROM         dbo.SalesInvoiceDET INNER JOIN
                      dbo.SalesInvoice ON dbo.SalesInvoiceDET.SalesInvoiceID = dbo.SalesInvoice.SalesInvoiceID INNER JOIN
                      dbo.PACKING ON dbo.SalesInvoice.SalesInvoiceID = dbo.PACKING.SALESINVOICEID INNER JOIN
                      dbo.PACKINGDET ON dbo.PACKING.PACKINGID = dbo.PACKINGDET.PACKINGID INNER JOIN
                      dbo.TOTALINARE1 ON dbo.SalesInvoice.SODISPATCHID = dbo.TOTALINARE1.SODISPATCHID INNER JOIN
                      dbo.SALESINVTOTALVALUE ON dbo.SalesInvoice.SalesInvoiceID = dbo.SALESINVTOTALVALUE.SalesInvoiceID