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. |
Showing posts with label JOIN and UNION. Show all posts
Showing posts with label JOIN and UNION. Show all posts
Friday, 9 May 2014
Difference Between JOIN and UNION
Subscribe to:
Posts (Atom)