Results 1 to 7 of 7

Thread: Using Join

  1. #1
    Expert Member
    Join Date
    Apr 2006
    Answers
    124

    Using Join

    Hi !
    whats the difference in using "inner join" and "right join" in sql queries?


  2. #2
    Administrator
    Join Date
    May 2006
    Answers
    331

    Re: Using Join

    Quote Originally Posted by bvani
    Hi !
    whats the difference in using "inner join" and "right join" in sql queries?

    Answer by Sriram Kammisetty

    Inner join : An inner join (sometimes called a "simple join") is a
    join of two or more tables that returns only those rows that satisfy the join condition.

    Outer Joins : An outer join extends the result of a simple join. An
    outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition



    : http://www.geekinterview.com/question_details/17658


  3. #3
    Junior Member
    Join Date
    May 2006
    Answers
    1

    Re: Using Join

    Hi ! i am working in oracle pl/sql and dba . I want to achive the ocp dba . And for that i need help to get the materials and questions and suggestion what should be best ways to achive this very fast and right version of oracle . Kindly let me know if you have the information . Thanks jayanta guha sr. Software engineer satyam computer services ltd.


  4. #4
    Expert Member
    Join Date
    May 2006
    Answers
    114

    Re: Using Join

    Right Join:
    A right join will display rows on the right side of the conditional that may or may not have a match. Outer joins are subdivided into left outer joins and right outer joins.


  5. #5
    Junior Member
    Join Date
    Feb 2007
    Answers
    4

    Re: Using Join

    hi
    i m doing d.b.a from system domain from nasik. i want to pass my first exam of two papers sql and fundamental1 so wat should i do for pass my exam so easily.


  6. #6
    Junior Member
    Join Date
    Feb 2007
    Answers
    5

    Lightbulb Re: Using Join

    Quote Originally Posted by bvani View Post
    Hi !
    whats the difference in using "inner join" and "right join" in sql queries?
    Hi bvani,
    Inner Join'll give u matching records and Right join'll give u all records from one tables and non-matching record on left table'l come as NULL.. in Simply, Right join'l give u all records from Right table and rest all unmatch Record'll give as NULL but Inner join'll give only matching rows between tables..

    Eg.,
    Table1
    c1 c2
    1 ABC
    2 DEF
    3 GHI
    4 JKL

    Table2
    p1 p2 c1
    1 ABC 1
    2 DEF 1
    3 GHI 1
    Execute these 2 Query
    Select * from Table2 t2
    Right Join Table1 t1 ON t2.c1 = t1.c1 -- this'l give 6 rows

    Select * from Table2 t2
    Inner Join Table1 t1 ON t2.c1 = t1.c1 -- this'll give 3 rows


    Thanks
    Vijay


  7. #7
    Expert Member
    Join Date
    Apr 2006
    Answers
    124

    Re: Using Join

    thanks vijay
    that was a good example


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact