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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
