Interbase allowed the following query:
SELECT SUM(ind_MoneyCollected)
FROM ProductQty PQ RIGHT JOIN
(InvoiceMaster IM JOIN InvoiceDetail ID ON ID.InvoiceMaster_ID =
IM.InvoiceMaster_ID AND ID.ind_Status <> 2 AND
IM.inm_TimeOut >=
:BeginDate AND IM.inm_TimeOut < :EndDate)
ON ID.ProductQty_ID = PQ.ProductQty_ID
JOIN Product P ON PQ.Product_ID = P.Product_ID
WHERE P.ProductLine_ID = 11
ORDER BY InvoiceMaster_ID

Firebird does not allow this because InvoiceMaster_ID is not in either
select list or aggregate function. But I do not want it in my select
list because I cannot have it in my GROUP BY clause. Any suggestions
to make this work with Firebird?
Thanks