+ 3

What's main difference btwn union and join?

2nd Jan 2016, 6:17 PM
shanmukh
shanmukh - avatar
6 Answers
+ 3
union increases no of rows join increases no of columns
14th Jul 2016, 7:42 PM
manish rawat
manish rawat - avatar
+ 2
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:09 AM
Samuel Mayol
Samuel Mayol - avatar
+ 1
In Sql, joins mean combining data from two or more table creates temporary joining .Join is done on 2 different table of same database having same colomn name.
14th Dec 2016, 5:10 PM
Sohel
0
Unions stack results vertically. The data type of every column must match, but the values don't have to match. Joins display results horizontally, but only need a single matching point of data. edit: I like the down votes for giving an accurate explanation. /s
13th Dec 2016, 3:13 AM
Taylor Rogers
Taylor Rogers - avatar
0
UNION does include records from two or more queries, however it will only show DISTINCT values. UNION ALL will show all records from the queries.
13th Dec 2016, 4:37 AM
kahyon
kahyon - avatar