what is difference between join and union?

Question Posted / sanjeev

3 Answers
9775 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is difference between join and union?..

Answer / rajeev singh

Join display exact information from two or more tables.
and it is not compulsory in both table column equal.

Where as in UNION in both table column should be equal.
and union eliminate the dublicate rows.

Is This Answer Correct ?

15 Yes

2 No

what is difference between join and union?..

Answer / sunil

JOIN: You can join the 2 tables on tables primary key or on
the filed which refers to another table

UNION: In both table while doing UNION the filed name
should be same.

Is This Answer Correct ?

2 Yes

2 No

what is difference between join and union?..

Answer / harish

JOIN: column wise joining of data.....
UNIOn: row wise joining of data........

Harish poomgame shivappa
NIIT Technolgies
Kolkata

Is This Answer Correct ?

8 Yes

9 No

Post New Answer