What is the difference between inner and outer join ?

[alendonald]

Hi,
I know little bit sql. I want to know about Inner join and outer join. And what is the difference between ?

[johnforster212]

A database operation that combines the values of 2 tables based on a condition, or relationship, that exists between those tables are called inner join.

An outer join defines a relationship between two tables where all records from one or both tables are returned regardless of the existence of a matching key-field in the other table.

[frankstine77]

Inner Join: Inner Join you used when you want to pull data that exit in both of the tables.
Outer Join: Outer Join you used when you want all of the matching data in first table regardless whether it or not exit in the second table.

[ricky ponting]

Joins are used to combine the data from two tables.
Difference between inner join and outer join are below

• An inner join will only select records where the joined keys are in both specified tables.
• A left outer join will select all records from the first table, and any records in the second table that match the joined keys.
• A right outer join will select all records from the second table, and any records in the first table that match the joined keys.

[avinash198]

inner joins= select records where the joined keys are in both specified tables.
outer joins= pull all of the matching data in the first table, regardless of whether or not it exists in the second table.

[Todaynews]

can you tell me the inner join and outer join syntax ?

[arun7]

Outer join defines the relation between two tables..Inner join combines values of two tables..

[sylvia]

Hi,
INNER JOIN means that any data that is matched in the ON clause has to be matched between both tables. So say one table has Bob, Jeb, and Fred and the other has Bill, Bob and Fred and you join on first name. INNER JOIN will find a match for only Bob and Fred in both tables thus Bill and Jeb will not be apart of the output.

OUTER JOIN dependning on RIGHT, LEFT or FULL will return all data from the reference tabled (LEFT being the first table named before the join predicate, RIGHT being the one right after and FULL being both). So a LEFT OUTER JOIN with the previous conditions where Jeb is in the first table before the join predicate will result in the records for Bob, Jeb and Fred but not Bill.

[justeatshilpa]

Outer join helps to find the relationship between the two data tables and inner join is used to pull the data..

[ankita339]

An INNER JOIN should be used when you only want to pull data that exists in both of the tables. Any entry found in the first table, that does not also have an entry in the second table, will not be included in the result set.
An OUTER JOIN should be used when you want to pull all of the matching data in the first table, regardless of whether or not it exists in the second table. Your result set will contain NULL for the variables that would have been found in the second table.
I agree with this statement.

[ankigupta]

inner join clubs the two rows by matching column field while outer join clubs all the rows of both tables.

[ahqaf]

Very important info. i learn many concept from this post.please,share more information.