Sean Lange (8/26/2015)
Ed Wagner (8/26/2015)
Going off the post about this query at http://www.sqlservercentral.com/Forums/Topic1714385-391-1.aspx#bm1714502, this is something called Firebird SQL.Interesting. As much I would be willing to help I think I will walk away from this. I know nothing about Firebird and anything I might suggest is highly likely to be incorrect for a database engine I have never heard of before.
I'm in the same boat. I had never heard of it until this week. A simple SUM and GROUP BY didn't work, so I'm at a complete loss as to what it is. Then again, I didn't do any research on Firebird. The only Firebird I know of is a car. 😛