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.
Both tables T1 and T2 will display values that both commonly have.