[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 … Continue reading [DATABASE]Difference between inner join, right and left outer join