What's main difference btwn union and join?

Answer 1

union increases no of rows join increases no of columns

Answer 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

Answer 3

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.

Answer 4

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

Answer 5

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.