Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Outer join with constants
Install Oracle and try it yourself.
"LJQ" <laojiqi_at_hotmail.com> wrote in message
news:84555688.0409170529.11509dc3_at_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 - 09:08:40 CDT