SELECT     TOP (100) PERCENT dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.PACKINGID, 
                      dbo.SalesInvoice.SalesInvoiceID, dbo.PACKING.DescriptionOfGoods, dbo.SALESORDERDET.CUSTPARTCODE, 
                      dbo.SALESORDERDET.CUSTPARTDESC, dbo.ITEM.ITEMNAME, dbo.FGSERIALNODET.SRNO, dbo.FGSERIALNODET.QTY, dbo.SALESORDER.SONO, 
                      dbo.ITEM.SPECIFICATION, dbo.SODISPATCH.SODISPATCHID, dbo.SALESORDER.CUSTOMERDETID, dbo.SALESORDER.SALESORDERID, 
                      dbo.SALESORDER.PONUMBER, dbo.SalesInvoice.SalesInvoiceNO, dbo.SALESORDER.PODATE
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
WHERE     (dbo.PACKING.PACKINGID = 6) AND (dbo.PACKING.APPROVE = 1) AND (dbo.PACKING.ONHOLD = 0) AND (dbo.PACKING.REJECT = 0)
ORDER BY dbo.FGSERIALNODET.SRNO