SELECT     TOP (100) PERCENT 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.PACKING.DescriptionOfGoods, 
                      dbo.CUSTOMER.EMAIL, dbo.SALESORDERDET.CUSTPARTCODE, dbo.SALESORDERDET.CUSTPARTDESC, dbo.ITEM.ITEMNAME, 
                      dbo.FGSERIALNODET.SRNO, dbo.FGSERIALNODET.QTY, dbo.SALESORDER.SONO, dbo.ITEM.SPECIFICATION, dbo.CUSTOMER.CITY, 
                      dbo.SODISPATCH.SODISPATCHID, dbo.CUSTOMER.CUSTOMERID, dbo.SALESORDER.CUSTOMERDETID, dbo.SALESORDER.SALESORDERID, 
                      dbo.SALESORDER.PONUMBER, dbo.SalesInvoice.SalesInvoiceNO, dbo.SALESORDER.PODATE, dbo.SalesInvoice.EXCHRATE AS EXCHINVRATE, 
                      dbo.SALESORDER.EXCHRATE, dbo.SALESORDERDET.QTY AS Qt, dbo.SALESORDERDET.UNITCOST, dbo.SALESINVTOTALVALUE.Expr1 AS Tot, 
                      dbo.ITEM.PRODCODE
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.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 INNER JOIN
                      dbo.FGRECEIVEDET ON dbo.SODISPATCHDET.SODISPATCHDETID = dbo.FGRECEIVEDET.SODISPATCHDETID INNER JOIN
                      dbo.FGSERIALNODET INNER JOIN
                      dbo.FGSERIALNO ON dbo.FGSERIALNODET.FGSERIALNOID = dbo.FGSERIALNO.FGSERIALNOID ON 
                      dbo.FGRECEIVEDET.FGRECEIVEDETID = dbo.FGSERIALNO.FGRECEIVEDETID INNER JOIN
                      dbo.SALESORDER ON dbo.SALESORDERDET.SALESORDERID = dbo.SALESORDER.SALESORDERID INNER JOIN
                      dbo.CUSTOMER ON dbo.SALESORDER.CUSTOMERID = dbo.CUSTOMER.CUSTOMERID INNER JOIN
                      dbo.SALESINVTOTALVALUE ON dbo.SalesInvoice.SalesInvoiceID = dbo.SALESINVTOTALVALUE.SalesInvoiceID
WHERE     (dbo.PACKING.APPROVE = 1) AND (dbo.PACKING.ONHOLD = 0) AND (dbo.PACKING.REJECT = 0)
ORDER BY dbo.FGSERIALNODET.SRNO