Hello, i have one TIBO_Query like this,

SELECT CO.CD
, CO.NOME
, EU.EMPRUSU_ID
, EU.CORR_ID
FROM EMPR_USU EU
, CORR CO
WHERE CO.CORR_ID = EU.CORR_ID
AND CO.CD = :CD
AND EXISTS ( SELECT 1
FROM PJ
WHERE PJ.CORR_ID = CO.CORR_ID )

Applying all fields in the "fields editor" i get this error message:

ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -204
Ambiguous field name between table EMPR_USU and table CORR
CORR_ID

STATEMENT:
TIBOInternalDataset:
"DataModuleForm.dmSyst003.qryEmpr_Usu.IBOqrqryEmpr_Usu."

I have a column CORR_ID in table EMPR_USU (foreign key) and
CORR (pk).

==> Delphi 6 + Patch 2 + IBO 4.2.Gc + Firebird WI-V1.0.0.794

Regards.

Edson Luis Gonçalez
Ribeirão Preto - SP - Brazil
edson@...