> 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 ?

Pete
====
http://www.howtodothings.com (Articles)
http://www.stuckindoors.com/delphi (Open source graphics / sound etc)