Subject | Re: [ib-support] FB RC1 |
---|---|
Author | Nando Dessena |
Post date | 2001-11-15T14:09:21Z |
Fabrice,
Read the release notes.
Disambiguate your where clause.
Ciao
--
____
_/\/ando
> SELECTA couple.
>
> 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?
Read the release notes.
Disambiguate your where clause.
Ciao
--
____
_/\/ando