benniecoetzer wrote:

>I have the following code in a Delphi program. Using GDS32.dll on the
>database works fine, however if I use fbclient I get the error message
>as shown. I was using Interbase 6.5 and am trying to convert to
>Firebird 1.5
>
>SQL statement
>
> 'SELECT * ' +
> ' FROM FIRSTTABLE A, SECONDTABLE B' +
> ' WHERE B.linkfield = A.linkfield';
>
>// ' FROM FIRSTTABLE, SECONDTABLE' +
>// ' WHERE FIRSTTABLE.linkfield = SECONDTABLE.linkfield';
>(This was another attempt but getting the same answer
>
>Error Message
>
>Database Server Error: Ambiguous field name between table FIRSTTABLE
>and table SECONDTABLE LINKFIELD
>
>Any suggestions?
>
>

Are you sure that this is teh complete statement ?

There is no ORDER BY clause ?

FB is more restrictive than IB in terms of ambiguous fields. This is
good, since IB could bring worng results.

If you full qualify the fields everywhere you should not get the
ambiguous field error message.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br