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

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1045

Why do we use functions?

895

What is difference between equi join and inner join?

919

What is the usage of sign function?

1081

What is SQL Azure Data sync?

119

List the different normalization forms?

960

Is sql server free?

894

Is there any difference between primary key and unique with the not null condition?

926

Is it possible to create trigger on views?

959

How to call a function from a stored procedure in SQL Server ?

1002

Why I can not enter 0.001 second in date and time literals in ms sql server?

1045

What is user defined datatypes and when you should go for them?

999

What is instead of dml trigger?

977

Explain iaas, paas and saas?

What is the Difference Between Primary and Foreign Key?

987