Hi !
whats the difference in using "inner join" and "right join" in sql queries?
Hi !
whats the difference in using "inner join" and "right join" in sql queries?
Originally Posted by bvani
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
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.
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