Subject | Re: Ambiguous field name between tables ... |
---|---|
Author | svein_erling |
Post date | 2002-08-14T12:33:56Z |
Hello Edson!
TIB_Query.
it complains about? Anyway, just try changing to explicit join and
see if that make any difference:
SELECT CO.CD
, CO.NOME
, EU.EMPRUSU_ID
, EU.CORR_ID
FROM EMPR_USU EU
JOIN CORR CO
ON CO.CORR_ID = EU.CORR_ID
WHERE CO.CD = :CD
AND EXISTS ( SELECT 1
FROM PJ
WHERE PJ.CORR_ID = CO.CORR_ID )
If this does not help, try to check your properties to see if you
reference a field that can be ambiguous, because this query is simple
and should work.
HTH,
Set
> Hello, i have one TIBO_Query like this,No, you do not - TIBO_Query does not exist, it could be TÃŒBOQuery or
TIB_Query.
> Ambiguous field name between table EMPR_USU and table CORRStrange, your query seems OK. Are you certain that it is this query
> CORR_ID
it complains about? Anyway, just try changing to explicit join and
see if that make any difference:
SELECT CO.CD
, CO.NOME
, EU.EMPRUSU_ID
, EU.CORR_ID
FROM EMPR_USU EU
JOIN CORR CO
ON CO.CORR_ID = EU.CORR_ID
WHERE CO.CD = :CD
AND EXISTS ( SELECT 1
FROM PJ
WHERE PJ.CORR_ID = CO.CORR_ID )
If this does not help, try to check your properties to see if you
reference a field that can be ambiguous, because this query is simple
and should work.
HTH,
Set