0

explain the types of join in easiest way.?

17th Oct 2016, 8:44 AM
kirti
1 Answer
+ 1
Just a question of matching. If you have the same values in two tables, inner join will display lines where there is a match with the two values. If not, inner join will display nothing. On the other hand, left or right outer join will display all lines with a match and all lines of one table even if there is no match. At the end, full outer join will display all lines of the two tables, match or not match.
10th Nov 2016, 10:05 AM
ABIVEN Vincent
ABIVEN Vincent - avatar