Subject Re: [IBDI] Ambiguous SQL :: Your Views Please
Author Peter Morris
> select a.compname from company a , employee b
> where a.compname = b.compname
> and b.empno = :empno
> order by compname
> The ambiguity here is that the statement does not identify which table's
compname to order by and the results are somewhat unpredictable -
contradictory, even, if you compare database versions.

In what way are the results unpredictable ?
Is it just a question of which indexes are used which causes it to slow
down, or something else ?
Surely if A.CompName B.CompName then they are both the same value and would
sort the same ?

==== (Articles) (Open source graphics / sound etc)