Subject | RE: [IBO] FieldName in query with joins and aliases 4.7 bevahes different than 4 |
---|---|
Author | Jason Wharton |
Post date | 2006-12-02T19:54:01Z |
> And also, in case of same fieldname, you could leave theHere's something to look at:
> responsibility to the developer, so you can have:
>
> select
> field1,
> table2.field2 as alias1,
> table1.field2
> from
> table1
> left join table2 on ...
>
> and have IBO return
> field1
> alias1
> table1.field2
What does Firebird 2.0 return for the relation alias name for alias1.
select
t1.field1,
t2.field2 as alias1,
t1.field2
from table1 t1
left
join table2 t2
on ...
Seems to me they would still go ahead and return t2. But, I suppose its
possible they may not.
Jason Wharton