FAQ
Folks

A basic Qs on Outer Join & its purpose?

Select A.f1, B.f2
From A,B
Where A.f3=B.f3(+)

Returns:-

ALL Rows from B
Only those rows from A where A.f3=B.f3
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***

Search Discussions

  • Hrishy at Jun 23, 2008 at 3:36 pm
    Hi Vivek

    Yes 3 seems to be the answer

    regards
    Hrishy
    On Mon, 23/6/08, VIVEK_SHARMA wrote:

    From: VIVEK_SHARMA
    Subject: Basic Qs on Outer Join ?
    To: "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***
    Sent from Yahoo! Mail.
    A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJun 23, '08 at 2:58p
activeJun 23, '08 at 3:36p
posts2
users2
websiteoracle.com

2 users in discussion

Hrishy: 1 post VIVEK_SHARMA: 1 post

People

Translate

site design / logo © 2022 Grokbase