left join vs inner join in case of where clause code example

Example: inner join vs outer join

INNER JOIN:
is used when retrieving data from multiple
tables and will return only matching data.


FULL OUTER JOIN:
is used when retrieving data from
multiple tables and will return both
table records, matching and non-matching.