View All num of num See all Photos Monster Worldwide This employer has taken extra steps to respond to reviews and provide job seekers with accurate company information, photos, and reviews. Interested for your company?Learn More. www.monster.com Employer Engaged Overview Reviews Salaries Interviews Jobs Photos Benefits 385 Reviews 435 Salaries 82 Interviews Follow Add Review or Salary Follow Add Review or Salary Interview Question Software Engineer Interview Maynard, MA Monster Worldwide In SQL, what is the difference between an inner and outer join? Tags: See more , See less 8 Answer Add Tags 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, Sign In or Sign Up.