GeekInterview.com
Series: Subject: Topic:
Question: 19 of 30

What is the difference in using inner join and outer joins?

Asked by: Interview Candidate | Asked on: Oct 20th, 2005
Showing Answers 1 - 2 of 2 Answers
Sriram Kammisetty

Answered On : Jan 17th, 2006

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

  
Login to rate this answer.
Harish Mahanta

Answered On : May 1st, 2006

Inner join:  It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.

Outerjoin:  This type of join returns all rows from one table and only those rows from a secondary table where the joined fields are equal (join condition is met).Here a (+) operator is uses for additional information of given table.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.