Re: Basic Qs on Outer Join ?

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Mon, 23 Jun 2008 15:36:36 +0000 (GMT)

Hi Vivek

Yes 3 seems to be the answer

regards
Hrishy


--- On Mon, 23/6/08, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:

> From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
> Subject: Basic Qs on Outer Join ?
> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
> 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***


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
--
//www.freelists.org/webpage/oracle-l


Other related posts: