Jump to content

invalid use of group error


TheJuan

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.