I am totally baffled by this one:

ISC ERROR MESSAGE
Dynamic SQL Error
SQL error code = -204
ROWS WITH TIES requires ORDER BY clause
PHONE

FOR SELECT LEAD_TRACKING_ID,CAST(PHONE AS
NUMERIC(10,0)),FIRSTNAME,MIDDLENAME,LASTNAME,ADDRESS,CITY,ST_ABBREV,ZIP ||
'-' || ZIP4,
CARD_LAST4,CARD_EXP,CARD_ABBREV
FROM MASTERLEADS,MASTERACTIVITY
WHERE MASTERLEADS.PHONE = MASTERACTIVITY.PHONE AND MASTERACTIVITY.TRID =
:TRID
INTO
:LEAD_TRACKING_ID,:PHONE,:FIRSTNAME,:MIDDLENAME,:LASTNAME,:ADDRESS,:CITY,:ST
ATE,:ZIP,:LAST4,:CARDEXP,:CARDTYPE
DO BEGIN
SUSPEND;
END

I am trying to create this procedure on Firebird 1.5. It used to work just
fine on IB 7.1. I just don't get it. I tried putting an ORDER BY PHONE
after the WHERE clause, but no good. I really sort of need some help here.
I cant get information out of db any other way.