Hi guys!

I have sql-operator:

SELECT tblSuites.nSeatMapID, tblAsheStadium.cSectionName, tblAsheStadium.cRowName, tblAsheStadium.nNumberOfSeat, tblAsheStadium.nNumberOfSeat - SUM(tblSuites.nNumberOfSeats) AS AvailableSuites FROM tblSuites INNER JOIN tblAsheStadium ON tblSuites.nSeatMapID = tblAsheStadium.nSeatMapID GROUP BY tblSuites.nSeatMapID, tblAsheStadium.cSectionName, tblAsheStadium.cRowName, tblAsheStadium.nNumberOfSeat HAVING (tblAsheStadium.nNumberOfSeat - SUM(tblSuites.nNumberOfSeats) > 0)

How correctly to make "HAVING" clause for HavingClause in GroupByCollection using LLBLGen?

Thanks!

If you mean how to formulate the expression inside the having clause, then you should implement IExpression as in the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3829

(edit) a similar thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6490