Using Join

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

[quote=bvani]Hi !
whats the difference in using "inner join" and "right join" in sql queries?[/quote]


Answer by [B]Sriram Kammisetty[/B]

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



[B] : [URL="http://www.geekinterview.com/question_details/17658"]http://www.geekinterview.com/question_details/17658[/URL][/B]

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.

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.

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.

[QUOTE=bvani;240]Hi !
whats the difference in using "inner join" and "right join" in sql queries?[/QUOTE]

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 :)

thanks vijay
that was a good example