What is the basic difference between a join and a union?

What is the basic difference between a join and a union?

The Basic diff are there :
> Joine is bassically use for the colums but in case of union is does't.
> Union is bassically us efor the rows but in case of the Join is does't.
> A join selects columns from Two or more tables. A union selects rows. 

By:UMANG
Date:2014-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher