Hi,

>
> select
> BASIC.USR_ID,BASIC.USR_PWD,BASIC.USR_NAME,BASIC.ROLE_ID,BASIC.USR_CODE,E
> XTENSIN.PROPERTY_NAME,EXTENSIN.PROPERTY_VALUE
> from USR_BASIC_INFO BASIC LEFT OUTER JOIN USR_EXTENSION_INFO EXTENSIN ON
> BASIC.USR_ID=EXTENSIN.USR_ID
> WHERE BASIC.USR_ID in ( select first 1 skip 0 usr_id from
> usr_basic_info)
>
>
>
> Pupose --> Select the first 'N" rows of the usr_basic_info and then
> apply the left outer join with usr_extension_info
>
> The clause [WHERE BASIC.USR_ID in ( select first 1 skip 0 usr_id from
> usr_basic_info)] works if the [FIRST n SKIP m] clause is removed.
>

AFAIK FIRST/SKIP is not supposed to work in subqueries (a shortcoming of
firebird).

hth,
Michael