On 3 Feb 2005 at 2:12, Edwin A. Epstein, III wrote:

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

Looks like you use IB client against FB server. Real error message
sounds "ambiguous field name "PHONE" between tables MASTERLEADS and
MASTERACTIVITY"

>FOR SELECT LEAD_TRACKING_ID,CAST(PHONE AS
>NUMERIC(10,0))

We all understand that in this case it is irrelevant which table
PHONE is selected from, but... FB 1.5 is very strict on this subject.
You must exactly define the field. I.e. MASTERLEADS.PHONE.
--
SY, Dimitry Sibiryakov.