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

How does clustered and non clustered index work?

527

What are the types of indexing?

605

How to verify the port number of the sql server?

565

What is the command dbcc checkdb used for?

541

How can sql server instances be hidden? : sql server security

605

How to make conditional sum in ssrs?

132

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

558

What is an index in a database?

549

What is store procedure? How do they work?

593

How to create hyperlink from returned sql query ?

634

Explain steps of normalization?

531

How can I tell if sql server is 32 or 64 bit?

507

What is the library index called?

607

What is the difference between NOROW and LOCKROW?

2255

Explain about thread and memory management process of SQL?

552