Cross Join: No join conditions are specified.
Results in pairs of rows.
Results in Cartesian product of two tables
.
Results in pairs of rows.
Results in Cartesian product of two tables
.
Full Outer Join:
A combination of both left and right outer joins.
Results in every row from both of the tables , at least once.
Assigns NULL for unmatched fields.
A combination of both left and right outer joins.
Results in every row from both of the tables , at least once.
Assigns NULL for unmatched fields.
No comments:
Post a Comment