Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    28

    Unanswered: Regarding Syntax of Some Join statements

    Dear Members

    I am new member of this forums, if any statement of mine hurts to anybody, please forgive me, but I will see to that nobody should.... and yes my English is some what not very good in grammatical aspect, so please forgive me for that also.

    This posting is for knowing the syntax of major join statements in oracle database of 9i version, the following are the statements:-

    1.Inner Join
    2.Left Outer Join
    3.Right Outer Join
    4.Self Join
    5.Cross Join
    6.Full outer Join

    Regards
    Praveen Kumar Pandey

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Welcome to the Forum!

    The following link will help you...

    http://www.dba-oracle.com/art_sql_iso_99.htm
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Aug 2004
    Posts
    28

    Smile Thank You CIS_GROUPIE

    Thank You cis_groupie

    The link you had provided to me solved my 50% of my problem.
    means:
    syntax of following statement is given:-
    1.left Outer Join
    2.right Outer Join
    3.Cross join

    and still the reamining 3 are there unresolved.

    With thanks and regards
    Praveen Kumar Pandey

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    This site could help you more, but you can find all you're after 'out there' - just do a search on the internet.

    http://www.ifi.uio.no/doc/oracle/ora...0/queries7.htm
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •