What are the differences between UNION and JOINS?

Question Posted / saravakumar

Answers were Sorted based on User's Feedback

What are the differences between UNION and JOINS?..

Answer / saravakumar

A join selects columns from 2 or more tables. A union
selects rows.

Is This Answer Correct ?

7 Yes

0 No

What are the differences between UNION and JOINS?..

Answer / sree

UNION:The SQL UNION operator combines two or more SELECT
statements.

JOINS:SQL joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.

Is This Answer Correct ?

4 Yes

0 No

What are the differences between UNION and JOINS?..

Answer / nikhila reddy

UNION:the both tables should have same structure and datatype.
the column name will taken as first table ones it wont bother abt other tables.
example:
emp table as
eid ename esal
1 a 10k
2 b 20k

dept table as
deptid deptname deptsal
11 aa 20k
12 bb 50k

select * from emp
union
select * from dept

empid empname empsal
1 a 10k
2 b 20k
11 aa 20k
12 bb 50k

now u can observe col name taking alias of first table.
no need of relation between a tables.
it will remove duplicate records.

joins:it will join only required fields from different tables.
no need of same structure for tables..
it should have relation between a tables.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer