At 05:59 AM 11/4/2004, jabangarita wrote:

>How does Firebird/Interbase nested select work in??
>
>
>SELECT t.risk, COUNT(t.name)
>FROM [SELECT t1.name, MAX(t1.risk) as risk
> FROM Table1 AS t1
> GROUP BY t1.name ]. AS t
>GROUP BY t.risk;

Firebird 1.5 and earlier don't handle select from select.
Firebird 2 does, but uses ISO syntax that does not
include square brackets. For earlier versions, turn
the inner select into a view or use a stored procedure.


Regards,


Ann