I wanted to retrieve 10 records starting from the 20th position, so I
wrote:

SELECT FIRST(10)
FROM ( SELECT SKIP(20) FROM CUSTOMER )

I got the following error msg:
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 2, char 8.
select.

Subsequently I found out that firebird doesn't really support sub-
queries, cos I got similar msg when I do the following:

SELECT *
FROM ( SELECT * FROM CUSTOMER )

Can somebody confirm me on this? Thanks.

--- In firebird-support@yahoogroups.com, Liliana PETER
<liliana_peter@y...> wrote:

> Hello Uwe
>
> At line 12 you have written EXITS, which is not an SQL
> keyword.
> I imagine you wanted to write EXISTS, which would make
> sense.
>
> Best regards
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree