Re: Basic Qs on Outer Join ?

Hi Vivek

Yes 3 seems to be the answer

regards
Hrishy

• On Mon, 23/6/08, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:

> From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
> Subject: Basic Qs on Outer Join ?
> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> Date: Monday, 23 June, 2008, 3:58 PM
> Folks
>
> A basic Qs on Outer Join & its purpose?
>
> Select A.f1, B.f2
> From A,B
> Where A.f3=B.f3(+)
>
> Returns:-
>
> 1. ALL Rows from B
> 2. Only those rows from A where A.f3=B.f3
> 3. For the rows (B.f3 - A.f3), is Value returned for
> field A.f1 Null ? (because corresponding Value of f3 does
> NOT exist in Table A, but exists in Table B)
>
> Cheers & Thanks V much
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL
> INFORMATION intended solely
> for the use of the addressee(s). If you are not the
> intended recipient, please
> notify the sender by e-mail and delete the original
> message. Further, you are not
> to copy, disclose, or distribute this e-mail or its
> contents to any other person and
> any such actions are unlawful. This e-mail may contain
> viruses. Infosys has taken
> every reasonable precaution to minimize this risk, but is
> not liable for any damage
> you may sustain as a result of any virus in this e-mail.
> You should carry out your
> own virus checks before opening the e-mail or attachment.
> Infosys reserves the
> right to monitor and review the content of all messages
> sent to or from this e-mail
> address. Messages sent to or from this e-mail address may
> be stored on the
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l