On Tue, 01 Apr 2003 00:29:46 -0500, Tom Lane <tgl@sss.pgh.pa.us>
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 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,
t2WHERE t1.f2=t2.f2(+) GROUP BY f1; SELECT t1.f1 FROM t1, t2 WHERE t1.f2(+)=t2.f2 GROUP BY f1;
all work.
ServusManfred