SELECT     dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.PACKINGID, dbo.CUSTOMER.CUSTOMERNAME, 
                      dbo.CUSTOMER.CUSTOMERID, dbo.SALESORDERDET.SALESORDERID, dbo.SalesInvoice.SalesInvoiceNO, dbo.SalesInvoice.SalesInvoiceDATE, 
                      dbo.FGRECEIVE.SLIPNO, dbo.PACKING.PACKINGDATE, dbo.Routes.Routes, dbo.PACKING.NetWeight, dbo.PACKING.GrossWeight
FROM         dbo.SalesInvoice INNER JOIN
                      dbo.PACKING ON dbo.SalesInvoice.SalesInvoiceID = dbo.PACKING.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.SALESORDER ON dbo.SALESORDERDET.SALESORDERID = dbo.SALESORDER.SALESORDERID INNER JOIN
                      dbo.CUSTOMER ON dbo.SALESORDER.CUSTOMERID = dbo.CUSTOMER.CUSTOMERID INNER JOIN
                      dbo.FGRECEIVE ON dbo.SODISPATCH.SODISPATCHID = dbo.FGRECEIVE.SODISPATCHID INNER JOIN
                      dbo.Routes ON dbo.SODISPATCH.RoutesID = dbo.Routes.RoutesID
GROUP BY dbo.PACKING.PACKINGID, dbo.CUSTOMER.CUSTOMERNAME, dbo.CUSTOMER.CUSTOMERID, dbo.SALESORDERDET.SALESORDERID, 
                      dbo.SalesInvoice.SalesInvoiceNO, dbo.SalesInvoice.SalesInvoiceDATE, dbo.FGRECEIVE.SLIPNO, dbo.PACKING.PACKINGDATE, dbo.Routes.Routes, 
                      dbo.PACKING.APPROVE, dbo.PACKING.ONHOLD, dbo.PACKING.REJECT, dbo.PACKING.NetWeight, dbo.PACKING.GrossWeight
HAVING      (dbo.PACKING.APPROVE = 1) AND (dbo.PACKING.ONHOLD = 0) AND (dbo.PACKING.REJECT = 0)