Re: [SQL] Using Aliases in Select

I'll take a stab at this one:

Try:
select tab1.name, tab1.mytext as text1, tab2.mytext as text2
from tab1, tab2 where tab1.tab1_id = tab2.tab1_id

I believe that this will fix it.

Andy

On Mon, 2 Aug 1999, Christian Rudow wrote:

> I join 2 tables that both have a row "mytext".
> I want to use both text fields in the select (projection) clause, giving
> alias names to them.
>
> select tab1.name, tab1.mytext text1, tab2.mytext text2
> from tab1, tab2
> where tab1.tab1_id = tab2.tab1_id
>
> but ...
>
> ERROR: Column 'mytext' is ambiguous
>
> Is there a solution to this ?
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Christian Rudow E-Mail: Christian(dot)Rudow(at)thinx(dot)ch
> ThinX networked business services Stahlrain 10, CH-5200 Brugg
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>