I'm not familiar with the use of the colon in sql, but the line, WHERE CO.CD
= :CD, bothers me. Should not :CD be, perhaps, :EU.CD?

jwc
-----Original Message-----
From: svein_erling [mailto:svein.erling.tysvaer@...]
Sent: Wednesday, August 14, 2002 8:34 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Ambiguous field name between tables ...


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


Yahoo! Groups Sponsor
ADVERTISEMENT




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
without the need for BDE, ODBC or any other layer.

___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]