[DATABASE]Difference between inner join, right and left outer join

Creating the tables

Data from T1

Data from T2

Left outer join
In the below example left table is T1 and right table is T2.
Left outer join will cause tuples of the left table (T1) to be preserved, the right table (T2) will display values that match the TID of the left, if there is no values matching the TID on the left NULL will be displayed.

Right outer join
In the below example right table is T2 and left table is T1. Right outer join will cause tuples of right table to be preserved and left table to display matching values, non-matching values will be NULL.

Inner join
Both tables T1 and T2 will display values that both commonly have.