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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is auditing in sql server?

880

Do you know exporting and importing utility?

972

Where are sql server usernames and passwords stored in the sql server?

1043

How to create a Master database in SQL server ?

1017

What are the restrictions that views have to follow? : SQL Server Architecture

945

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1988

What are Spatial data types in SQL Server 2008

963

What is spatial and temporal data?

931

Explain sql server service broker?

925

Explain the difference between clustered and non-clustered index?

870

What are the different types of stored procedures?

1066

Explain what is the purpose of sql profiler in sql server?

1009

What are different types of schemas?

894

Do you know what is sql service broker?

995

What are sql servers used for?

980