Subject Re: [firebird-support] Re: first , skip
Author Helen Borrie
At 02:52 AM 5/08/2004 +0000, you wrote:
> Fb 1.5.1 ss
> Following sql does not work
> SELECT first 10 skip 5 * FROM mytable
> isc error 335544569
> Following sql works ok :
> SELECT first 10 skip 5 m.* FROM mytable m
> If I do not use skip xxx then it works either way.
> Is this as it should be ? Or is it just me ?

This actual query works fine on an actual table in a database here:

select first 10 skip 5 * from ff_transaction

If you are querying multiple tables, then your first syntax is wrong (hence
the DSQL exception) and your second syntax, as part of a mixed-table
select, is correct. Fb 1.5 treats multi-table query specs (select
statements containing joins or subqueries) as ambiguous if they are not
fully qualified with consistent aliases, and rejects them.