Manfred Koizar <[EMAIL PROTECTED]> writes:
> MSSQL7:
> SELECT t1.f1
> FROM t1 {INNER | LEFT | RIGHT} JOIN t2 ON (t1.f2=t2.f2)
> GROUP BY f1
> all run without an error.
> ORACLE7: JOIN syntax not available, but
> SELECT t1.f1 FROM t1, t2 WHERE (t1.f2=t2.f2) GROUP BY f1;
> SELECT t1.f1 FRO
On Tue, 01 Apr 2003 00:29:46 -0500, Tom Lane <[EMAIL PROTECTED]>
wrote:
>Just out of curiosity --- does MSSQL treat "f1" and "t1.f1" as different
>in the RIGHT JOIN variant case I mentioned?
MSSQL7:
SELECT t1.f1
FROM t1 {INNER | LEFT | RIGHT} JOIN t2 ON (t1.f2=t2.f2)
GROUP BY f1
all run with
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
Joe Conway <[EMAIL PROTECTED]> writes:
> I did the above on MSSQL2000 -- it works with no error.
Just out of curiosity --- does MSSQL treat "f1" and "t1.f1" as different
in the RIGHT JOIN variant case I mentioned? Previous reports have led
me to have a very low estimate of their [understanding of
Tom Lane wrote:
I have just noticed that 7.3 and CVS tip reject a query that was
accepted in earlier releases:
regression=# create table t1(f1 int, f2 int);
CREATE TABLE
regression=# create table t2(f2 int, f3 int);
CREATE TABLE
regression=# select t1.f1 from t1 join t2 on (t1.f2=t2.f2) group by f1
