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