What is the difference between join and union.
Answer Posted / blue shark
JOIN:
-----
A Join is used for displaying columns with the same or
different names from different tables. The output displayed
will have all the columns shown individually. i.e. The
columns will be aligned next to each other.
UNION:
------
The UNION set operator is used for combining data from two
tables which have columns with the same datatype.
When a UNION is performed the data from both tables will be
collected in a single column having the same datatype.
For eg:
See the two tables shown below:
Table t1
Articleno article price manufacturer_id
1 hammer 3 $ 1
2 screwdriver 5 $ 2
Table t2
manufacturer_id manufacturer
1 ABC Gmbh
2 DEF Co KG
Now for performing a JOIN type the query shown below
SELECT articleno, article, manufacturer
FROM t1 JOIN t2 ON (t1.manufacturer_id =
t2.manufacturer_id);
articelno article manufacturer
1 hammer ABC GmbH
2 screwdriver DEF Co KG
That is a join.
UNION means that you have to tables or resultset with the
same amount and type of columns and you add this to
tables/resultsets together. Look at this example:
Table year2006
Articleno article price manufacturer_id
1 hammer 3 $ 1
2 screwdriver 5 $ 2
Table year2007
Articleno article price manufacturer_id
1 hammer 6 $ 3
2 screwdriver 7 $ 4
SELECT articleno, article, price, manufactruer_id
FROM year2006
UNION
SELECT articleno, article, price, manufacturer_id
FROM year2007
articleno article price manufacturer_id
1 hammer 3 $ 1
2 screwdriver 5 $ 2
1 hammer 6 $ 3
2 screwdriver 7 $ 4
Hope this helps!
Is This Answer Correct ? | 107 Yes | 11 No |
Post New Answer View All Answers
explain access control lists. : Sql dba
Why is sql*loader direct path so fast?
which types of join is used in sql widely? : Sql dba
What are database links used for?
Why are sql stored procedures used?
what is the difference between char_length and length? : Sql dba
What are expressions?
What is the usage of sql functions?
What is the difference between local and global temporary table?
What are the types pl/sql code blocks?
Explain architecture of sql server notification services?
how to see the create table statement of an existing table? : Sql dba
How do you declare a variable in pl sql?
What is lookup table in sql?
How many subqueries can be nested in a statement?