--- In ib-support@y..., Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

>you want to order the result set, i.e. order by 1 or
> order by ID_ALOJ_GRJ (without the P.).

Hi, Svein, Marcos. There certainly no such limitation in SELECT
statement syntax, join can contain more than 1 column with the same
name (in different tables), so we can use table alias in ORDER BY and
GROUP BY. So, I think it's really bug or corrupted database - broken
index, for example.
Marcos, will problem remain if you backup and restore your database?

Best regards.