Hi,

The following query, which worked without problem with Firebird < RC1
now generates an error:

SELECT

C.CARDHOLDER_ID
, C.FAMILY_ID
, T.TOKEN_ID
, T.CARD_NUMBER
, T.PINCODE

FROM CARDHOLDER C

LEFT OUTER JOIN TOKEN T
ON C.CARDHOLDER_ID = T.CARDHOLDER_ID

WHERE CARDHOLDER_ID = 1


The error message is:
ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -204
Ambiguous field name between table/view TOKEN and table/view
CARDHOLDER
CARDHOLDER_ID

Any idea?

Regards,
Fabrice
mailto:fabrice.aeschbacher@...