+ 2

What is the difference between Union and Join?

18th Jul 2016, 8:04 AM
Preeti.Bhushania
Preeti.Bhushania - avatar
4 Answers
+ 7
UNION combines the results of two or more queries into a single result se. JOINs you can retrieve the data from two or more tables based on logical relationship between the tables.
18th Jul 2016, 8:28 AM
Nitin jain
+ 7
if tables are joined one above other it is union if tables are joined side by side it is join
19th Jul 2016, 4:52 PM
manish rawat
manish rawat - avatar
+ 2
'union' selects the same type of data (the same columns) from more than one table - like adding the next table to the bottom of the previous one; 'join' selects different type of data (different columns) from more than one table - like adding more columns next to the first table.
4th Aug 2016, 8:08 PM
Ganna Malyenkina
Ganna Malyenkina - avatar
+ 1
What many SoloLearn users are doing is searching "join vs union" on the Internet and posting that as part of their answer. I am going to respect authors or bloggers response and I am going to provide you two links that is going to take you to the concepts and examples, step-by-step in what is a "join" and what is an "union". At the end you will have your own understanding and conclusion what is a join vs union. http://www.w3schools.com/sql/sql_join.asp http://www.w3schools.com/sql/sql_union.asp
30th Dec 2016, 1:10 AM
Samuel Mayol
Samuel Mayol - avatar