I don't see any SUM or other aggregate functions here (except MIN and MAX), so it ought to be simple to replace this with one or two [NOT] EXISTS in your WHERE clause.

Not knowing the rest of your query, I will not attempt to rewrite it.

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of mthendley
Sent: 26. november 2007 17:32
To: firebird-support@yahoogroups.com
Subject: [firebird-support] HAVING Clause in Firebird vs. Interbase

When using Interbase, we had the following HAVING clause in a query,
which is not allowed in Firebird. Any suggestions on how to rework
this in Firebird? Let me know if you need more info.

HAVING (sch_StartTime+0.00348) < (f_StripDate(Min(CheckInTime))-1)
OR (sch_EndTime-0.00348) > (f_StripDate(Max(chk_CheckOutTime))-1)

Thanks