Interview Question

Interview Maynard, MA

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


Interview Answer

1 Answer


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, Sign In or Sign Up.