Welcome Guest. Sign in or Signup

1 Answers

Inner Join vs Outer Join

Asked by: 1952 views SQL

As a part of Normalization, we organize / store our data into many different tables. At any point when data is required, we run an SQL select statement joining multiple tables and pull out the data together. What are the difference between Inner Join and Outer Join from a result perspective?

Related Questions

1 Answers

  1. M Kapras on Mar 18, 2016 Reply

    Inner join returns only those rows which satisfy the join conditions. An outer join returns those same rows plus some or all other rows from one of the tables where no rows satisfy the join condition in the other table.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes

Answer Question