Subject Re: [IBO] Searching and column aliases
Author yeohray
--- In IBObjects@y..., Geoff Worboys <geoff@t...> wrote:
> > Because column aliases is easier to use, and I don't have to set
>
> Obviously its your choice but neither of these reasons make a whole
> lot of sense to me...
>
> eg. When looping through the fields adding aliases, just add the
> values to the the FieldsDisplayLabel instead.
>
> All the Fields* properties support table.field_name=xxxx format so
> that they can resolve such issues.
>
>
> Avoiding aliases avoids the issue of aliases not working for sql
> manipulations, plus various support is integrated into IBO
> specifically for the labels.
>
>
> --

How can I avoid using aliases if my query is returning two columns
with the same name from two different tables?

Regards
Ray