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?