inner join vs outer join code example

Example 1: difference between inner join vs outer join

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

LEFT OUTER JOIN:
is used when retrieving data from
multiple tables and will return
left table and any matching right table records.

RIGHT OUTER JOIN:
is used when retrieving data from
multiple tables and will return right
table and any matching left table records

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

Example 2: inner class vs outer class

1. Can Outer class be static? --> No
2. Can inner class be static? --> Yes
3. Can you create an object from the inner class? --> Only if it's static
4. Can we have main method in inner class ? --> Only if it's static
5. Inner class can only be extended if it's static.

Example 3: 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.