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 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 WHERE t1.f2=t2.f2(+) GROUP BY f1; SELECT t1.f1 FROM t1, t2 WHERE t1.f2(+)=t2.f2 GROUP BY f1; all work. Servus Manfred ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org