Subject Re: [firebird-support] Nested Select
Author Ann W. Harrison
At 05:59 AM 11/4/2004, jabangarita wrote:

>How does Firebird/Interbase nested select work in??
>SELECT t.risk, COUNT(
>FROM [SELECT, MAX(t1.risk) as risk
> FROM Table1 AS t1
> GROUP BY ]. 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.