Friday, 9 May 2014

Difference Between JOIN and UNION

Difference Between JOIN and UNION


                      Join                    Union
    1. Join the columns.
2. Duplicate are allowed

3.Combine the column based on condition.		1.Merge the row
2.Duplicates are not allowed

3. Combine the result of two select statements.
Labels: ,