Tom Lane wrote:
> Just out of curiosity ---
Here's what I get:
select * from t1
f1 f2
----------- -----------
1 1
2 2
(2 row(s) affected)
select * from t2
f2 f3
----------- -----------
1 3
(1 row(s) affected)
select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.
select f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.
select f2 from t2 right join t1 on t1.f2 = t2.f2 group by f2
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.
Server: Msg 209, Level 16, State 1, Line 1
Ambiguous column name 'f2'.
select t1.f2 from t2 right join t1 on t1.f2 = t2.f2 group by t1.f2
f2
-----------
1
2
(2 row(s) affected)
Any other variations you want to see?
Joe