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.
|
No comments:
Post a Comment