Subject | Ambiguous field |
---|---|
Author | Valdir Stiebe Junior |
Post date | 2003-05-02T19:28:52Z |
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.
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.