How to catch a fool

Recipe:

Create table Company (uniqnum integer not nul,
compname varchar(40),
primary key (uniquenum))

Create table Employee (uniqnum integer not nul,
empno integer not nul
compname varchar(40),
primary key (uniquenum,empno))

Well, the displayed order by company name of

select a.compname from company a , employee b
where a.compname = b.compname
and b.empno = :empno
order by compname

ordering was fine.

However the ordering became random after I recompiled
IBO4 I thought. But then I also installed FB1..2b.
It turned out that old IB6 ordered by compname from
Company and the new FB1 by compname of Employee.

Moi, fool, did'nt use "order by a.compname", but I
taught my dictonary a few new words. Tried to stuff
that in TIBOQuery's Orderlink, but have to keep it
part of the SQL.

Best Regards
Hans