SELECT     dbo.PACKING.PACKINGID, dbo.PACKTYPE.PACKTYPE, dbo.SALESORDERDET.SALESORDERID, dbo.SALESORDER.PONUMBER, 
                      dbo.FGSERIALNO.FROMSRNO AS TOTBOX, dbo.FGSERIALNODET.QTY AS TOTQTY, dbo.PACKTYPE.PACKTYPEID, dbo.ITEM.PRODCODE, 
                      dbo.ITEM.SPECIFICATION, CAST(dbo.FGRECEIVEDET.NETWEIGHT AS FLOAT) AS Expr1, dbo.FGRECEIVE.WeightKg AS UNITWT
FROM         dbo.FGRECEIVEDET INNER JOIN
                      dbo.FGRECEIVE ON dbo.FGRECEIVEDET.FGRECEIVEID = dbo.FGRECEIVE.FGRECEIVEID INNER JOIN
                      dbo.PACKING INNER JOIN
                      dbo.SalesInvoice ON dbo.PACKING.SALESINVOICEID = dbo.SalesInvoice.SalesInvoiceID ON 
                      dbo.FGRECEIVE.SODISPATCHID = dbo.SalesInvoice.SODISPATCHID INNER JOIN
                      dbo.PACKTYPE ON dbo.FGRECEIVE.PACKTYPEID = dbo.PACKTYPE.PACKTYPEID INNER JOIN
                      dbo.FGSERIALNO ON dbo.FGRECEIVEDET.FGRECEIVEDETID = dbo.FGSERIALNO.FGRECEIVEDETID INNER JOIN
                      dbo.FGSERIALNODET ON dbo.FGSERIALNO.FGSERIALNOID = dbo.FGSERIALNODET.FGSERIALNOID INNER JOIN
                      dbo.SODISPATCHDET ON dbo.FGRECEIVEDET.SODISPATCHDETID = dbo.SODISPATCHDET.SODISPATCHDETID 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.ITEM ON dbo.SALESORDERDET.ITEMID = dbo.ITEM.ITEMID AND dbo.FGRECEIVEDET.ITEMID = dbo.ITEM.ITEMID