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

What are the differences between UNION and JOINS?

Question Posted / saravakumar

Answer Posted / saravakumar

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

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is change data capture (cdc) feature?

1069

Do you know what is difference between stored procedure and user defined function?

1094

Why I have to use stored procedures?

1050

What is snapshot report?

165

What is the maximum size of sql server database?

1011

What are the different types of backups avaialabe in sql server 2005?

1022

Can you explain different types of locks in sql server?

947

What do you mean by an execution plan? Why is it used?

1027

Why do we need different type of parameter?

1058

if no size is defined while creating the database, what size will the database have? : Sql server administration

1010

What is the Main Difference between ACCESS and SQL SERVER?

1137

What options are available to audit login activity? : sql server security

1153

How to display a past time in days, hours and minutes?

1016

Do comments need to go in a special place in sql server 2005?

860

What is difference between delete and truncate commands?

1084