Monster Worldwide

  www.monster.com
  www.monster.com

Interview Question

Software Engineer Interview Maynard, MA

In SQL, what is the difference between an inner and outer

  join?
Answer

Interview Answer

1 Answer

0

An inner join is the standard method of linking two tables using a common row of data in each table. Only those rows that match on the common data will be returned in the result set.

An outer join returns the results from tables even if there is no match on common data with nulls for the columns where there is no match. A Left Outer Join will return all rows from the first table; a Right Outer Join returns all rows from the second table, and a Full Outer Join returns all rows from both tables.

Interview Candidate on Jul 13, 2010

Add Answers or Comments

To comment on this Question, Sign In with Facebook or Sign Up