Subject Re: Ambiguous field name between tables ...
Author svein_erling
Hello Edson!

> 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 CORR
> CORR_ID

Strange, your query seems OK. Are you certain that it is this 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