Re: Outer join with constants

From: LJQ <laojiqi_at_hotmail.com>
Date: 17 Sep 2004 18:02:30 -0700
Message-ID: <84555688.0409171702.5eca8779@posting.google.com>

> Come on now. What does running it on Oracle have to do with it?
> These are all well defined selects. The two with 1=1 are equivalent
> to the same selects without the "and 1=1". The left join
> with 1=2 returns all rows of J1 with nulls in the J2 columns.
> The full join with 1=2 does that, and additionally outputs all
> rows of J2 with nulls in the J1 columns.
>
> If Oracle does anything different, it's a bug.
>
> For your homework, you can figure out what writing "or 1=1" instead
> of "and 1=1" does.
>
> Karl

Hi, there,

Have you ever tried it with Oracle before you make your conclusion (on the full outer join)? Received on Fri Sep 17 2004 - 20:02:30 CDT