Ah, good point. I didn't write the original query and clearly
overlooked the obvious on that one. Thanks!

--- In firebird-support@yahoogroups.com, Woody <woody-tmw@...> wrote:
>
> mthendley wrote:
> > 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
> >
>
> Why would you want to order by a calculation that only returns one
> result? Of what use could it be?
>
> Woody (TMW)
>