sql join
Left join
The result set of left join is : Carterisan product of meet the join conditions of table A and table B + rest of table A
Inner join
The result set of inner join only is the Carterisan product of meet the join conditions of table A and table B
Written on November 14, 2015