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