Diane,
Are you saying that

SELECT tab.x
FROM tab myalias

is wrong, because the original table name is totally hidden by alias ??

Ivan
http://www.volny.cz/iprenosil/interbase

> > > SELECT RQSEL.D_KEYID
> > > FROM RQSEL
> > > INNER JOIN RQSEL R1
> > > ON (RQSEL."D_KEYID" = R1."D_KEYID")
> > > WHERE
> > > (RQSEL.WO_WORD = 'CIVILES' AND R1.WO_WORD = 'ADMIN')
>
> It's ambiguous: one of the table instances is not qualified, so what

should

> the engine use? When a table appears twice, both places should carry

an

> alias. Otherwise, results are almost random.

What's ambiguous here? One instance is "RQSEL", the other is "R1".
As far as I can see, all column references are qualified with one name
or the other.
What's not to like?