Hi Edward,
> Just a guess, but it seems to me that since the join is using col1 and col2
> there is no ambiguity. They should be the same no matter which table it
> comes from.
Not always the same; "Left join" may return:
table2.col1,col2 = null,
while table1.col1,col2 is not null
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
> On Behalf Of Emi Lu
> Sent: Friday, August 22, 2008 4:12 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Why *no* ambig.uous complain in select part?
>
> Good morning,
>
> Just notice one small thing, and need your information about select
>
> select col1, col2
> from table1
> left join table2
> using (col1, col2)
>
> ;
>
> This query never complain about ambiguous columns of col1 and col2 in
> the select part.
>
> My guess is:
> (1) col1, col2 always return table1.col1, table1.col2
> (2) because using (col1, col2)
> that's why, table name is not necessary in select part
>
> Am I wrong? Please advise?
>
> Thank you!
>
>
>
>