Subject Re: Sub-Query Problem
Author Alfred Seetoh
> Alfred, this can confirm IB6 Open Source Language Reference
where
> syntax of SQL dialect used in FB is described. Note IB6 docs are
> generally legal for FB, differences are described in Release Notes
for
> particular FB version. But there is terminological nuance - what we
> call sub-query? If SELECT FROM SELECT - FB don't support this. If
> constructions like
>
> Select T1.A, (Select T2.B From T2)
> From T1
>
> Or
>
> Select T1.A
> Where T1.B=(Select T2.B From T2)
>
> - they are legal for FB.
>
> Looking on your initial query I suspect you really want something
> like
>
> SELECT FIRST(10) SKIP(20) * FROM CUSTOMER
>
> Am I wrong?

Yes that's what I want, thanks.

>
> Best regards,
> Alexander.