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 without an
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 FROM t1, t2
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;
ERROR:
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
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
