TheJuan Posted July 3, 2008 Share Posted July 3, 2008 hi i really spent my time on this one. SELECT tblinitemdetail.QuantityIn, tblinitemdetail.UnitUsed, tbltransactioninid.`Date`, tblitemid.ProductName, tblinitemdetail.ItemDetailID, SUM(tblrequestdetail.QuantityOut) AS Total_Out, tblinitemdetail.QuantityIn - SUM(tblrequestdetail.QuantityOut) AS Balance, tblrequestdetail.QuantityOut FROM tblrequestdetail INNER JOIN tblinitemdetail ON (tblrequestdetail.ItemDetailID = tblinitemdetail.ItemDetailID) INNER JOIN tbltransactioninid ON (tblinitemdetail.TransactionInID = tbltransactioninid.TransactionInID) INNER JOIN tblitemid ON (tblinitemdetail.ItemID = tblitemid.ItemID) WHERE (tblinitemdetail.QuantityIn - SUM(tblrequestdetail.QuantityOut)) <= '10' GROUP BY tblinitemdetail.QuantityIn, tblinitemdetail.UnitUsed, tbltransactioninid.`Date`, tblitemid.ProductName, tblinitemdetail.ItemDetailID, tblrequestdetail.QuantityOut ORDER BY tblinitemdetail.QuantityIn - SUM(tblrequestdetail.QuantityOut) ASC everything is fine with out this line: WHERE (tblinitemdetail.QuantityIn - SUM(tblrequestdetail.QuantityOut)) <= '10' Link to comment https://forums.phpfreaks.com/topic/113039-invalid-use-of-group-error/ Share on other sites More sharing options...
fenway Posted July 3, 2008 Share Posted July 3, 2008 You can't use an aggregate expression in the WHERE clause -- move it to a HAVING clause. Link to comment https://forums.phpfreaks.com/topic/113039-invalid-use-of-group-error/#findComment-580772 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.