Difference between Inner Join and Outer Join

Inner Join vs Outer Join

The Inner join returns only the rows for which there is an match in both tables.
The Inner join eliminate the rows that do not match with a row from the other table.
The Outer join returns unmatched rows.
The Outer join return all rows from at least one of the tables.

Students table:

IDNAMECITY
1EmmaNew York
2DanielChicago
3JosephDallas
4JenniferLos Angeles
5DebraDallas

Library table:

IDTITLESTUDENT_ID
1SQL3
2T-SQL1
3MSSQL5
4PHP1
5CSS2

Inner Join

select s.ID, s.Name, l.Title
from Students s
INNER JOIN Library l
on s.ID=l.Student_id;

Results

IDNAMETITLE
1EmmaT-SQL
1EmmaPHP
2DanielCSS
3JosephSQL
5DebraMSSQL

Full Outer Join

select s.ID, s.Name, l.Title
from Students s
FULL OUTER JOIN Library l
on s.ID=l.Student_id;

Results

IDNAMETITLE
1EmmaT-SQL
1EmmaPHP
2DanielCSS
3JosephSQL
4JenniferNULL
5DebraMSSQL