Subject | Ambiguous query or bug ? |
---|---|
Author | Béru |
Post date | 2001-12-03T11:05:50Z |
JJM posted the following problem on the french IB newsgroup:
I don't think there is an ambiguity in his query... Is this a known
bug in the ambiguities-checking code ?
Berenger
> SELECT RQSEL.D_KEYIDRQSEL.D_KEYID.
> FROM RQSEL
> INNER JOIN RQSEL R1
> ON (RQSEL."D_KEYID" = R1."D_KEYID")
> WHERE
> (RQSEL.WO_WORD = 'CIVILES' AND R1.WO_WORD = 'ADMIN')
>
> j'obtiend le message :
> Undefined name.
> Dynamic SQL Error.
> SQL error code = -204.
> Ambiguous field name between table/view RQSEL and table/view
I don't think there is an ambiguity in his query... Is this a known
bug in the ambiguities-checking code ?
Berenger