Hi,

Both your tables have a column 'CARDHOLDER_ID' - in the WHERE clause, use C.CARDHOLDER_ID.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."





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





[Non-text portions of this message have been removed]