Re: [SQL] Using Aliases in Select - Mailing list pgsql-sql

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.Rudow@thinx.ch
> ThinX networked business services    Stahlrain 10, CH-5200 Brugg
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>