|Subject||Re: [IBDI] Ambiguous SQL :: Your Views Please|
> select a.compname from company a , employee bcompname to order by and the results are somewhat unpredictable -
> 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
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 ?
http://www.stuckindoors.com/delphi (Open source graphics / sound etc)