SELECT     dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.PACKINGID, dbo.CUSTOMER.PHONENO, 
                      dbo.CUSTOMER.FAXNO, dbo.CUSTOMER.PINCODE, dbo.CUSTOMER.ADDRESS3, dbo.CUSTOMER.ADDRESS2, dbo.CUSTOMER.ADDRESS1, 
                      dbo.CUSTOMER.CUSTOMERNAME, dbo.CUSTOMER.COUNTRY, dbo.SalesInvoice.SalesInvoiceID, dbo.SalesInvoice.SalesInvoiceNO, 
                      dbo.CUSTOMERDET.CONTACTPERSON, dbo.PACKING.DescriptionOfGoods, dbo.CUSTOMER.EMAIL, dbo.PACKINGDET.BoxesQty, 
                      dbo.SALESORDERDET.CUSTPARTCODE, dbo.SALESORDERDET.CUSTPARTDESC, dbo.ITEM.ITEMNAME
FROM         dbo.PACKING INNER JOIN
                      dbo.SalesInvoice ON dbo.PACKING.SALESINVOICEID = dbo.SalesInvoice.SalesInvoiceID INNER JOIN
                      dbo.SODISPATCH ON dbo.SalesInvoice.SODISPATCHID = dbo.SODISPATCH.SODISPATCHID INNER JOIN
                      dbo.CUSTOMERDET INNER JOIN
                      dbo.CUSTOMER ON dbo.CUSTOMERDET.CUSTOMERID = dbo.CUSTOMER.CUSTOMERID ON 
                      dbo.SODISPATCH.CUSTOMERID = dbo.CUSTOMERDET.CUSTOMERID INNER JOIN
                      dbo.PACKINGDET ON dbo.PACKING.PACKINGID = dbo.PACKINGDET.PACKINGID INNER JOIN
                      dbo.SODISPATCHDET ON dbo.SODISPATCH.SODISPATCHID = dbo.SODISPATCHDET.SODISPATCHID INNER JOIN
                      dbo.SALESORDERDET ON dbo.SODISPATCHDET.SALESORDERDETID = dbo.SALESORDERDET.SALESORDERDETID INNER JOIN
                      dbo.ITEM ON dbo.SALESORDERDET.ITEMID = dbo.ITEM.ITEMID