Try my app Expense Manager @ google play and amazon store.

Wednesday, July 4, 2012

Cross Join and Full Outer Join in SQL Server

Cross Join

There is no join conditions specified in Cross JoinResults will be Cartesian product of two tables participating in joinResults in pairs of rows.

Full Outer Join

It is combination of both left and right outer joins. Results in every row from both of the tables , at least once. It assigns NULL for unmatched fields.

No comments:

Post a Comment

Follow by Email

Google+ Badge