Re: Going mad - outer join problem
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Sun, 2 Nov 2008 13:54:48 -0800 (PST)
Message-ID: <d3623db9-bcd0-48b3-9f18-ea7ecf467e86@e1g2000pra.googlegroups.com>
Date: Sun, 2 Nov 2008 13:54:48 -0800 (PST)
Message-ID: <d3623db9-bcd0-48b3-9f18-ea7ecf467e86@e1g2000pra.googlegroups.com>
Remember that for outer joins there is also difference between
predicates in ON clause vs. predicates in WHERE clause
See more http://www.gplivna.eu/papers/sql_join_types.htm#p6.4
Gints Plivna
http://www.gplivna.eu/
On 19 Okt., 19:42, Jeremy <jeremy0..._at_gmail.com> wrote:
> Oracle 10g 10.2.0.1.0
>
> Take two tables A and B.
<skipped>
Received on Sun Nov 02 2008 - 15:54:48 CST