Hi,

At May 2, 2003, 16:28, Valdir Stiebe Junior wrote:

> Hi,
> I'm using Firebird 1.0 and i'm not getting the exception that should be
> raised about the ambiguous fields.
> I'm doing this

> select *
> from
> MY_PROCEDURE(params) MP left outer join
> TEST_TABLE T1 on MP.ID_TT = T1.ID_TT left outer join
> TEST_TABLE T2 on T2.ID_TT_MASTER = T1.ID_TT
> where
> ID_STATUS = 2 <<=== Should raise an exception!?

> The problem here is that the person who wrote this SQL didn't used the table
> alias at the where, but it don't raised any exception.

Which dialect that the database is using? The ambiguous field error
occurs when using dialect 3, but not with dialect 1.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)