Outer join with constants

From: LJQ <laojiqi_at_hotmail.com>
Date: 17 Sep 2004 06:29:34 -0700
Message-ID: <84555688.0409170529.11509dc3@posting.google.com>

Hello, Gurus,

Since Tom is on vacation, I would like to hear from you. For ANSI outer join syntax, how oracle handle the following and what result can we expect?

I KNOW there is no real-world meaning, I just want to know how oracle takes these.

SELECT * FROM J1 left outer join J2 on (j1.c1 = j2.c1 and 1=1); SELECT * FROM J1 left outer join J2 on (j1.c1 = j2.c1 and 1=2);

SELECT * FROM J1 full outer join J2 on (j1.c1 = j2.c1 and 1=1); SELECT * FROM J1 full outer join J2 on (j1.c1 = j2.c1 and 1=2);

Thanks in advances. Received on Fri Sep 17 2004 - 08:29:34 CDT