UNION:The SQL UNION operator combines two or more SELECT statements. JO

What are the differences between UNION and JOINS?

Question Posted / sree

Answer Posted / sree

UNION:The SQL UNION operator combines two or more SELECT
statements.

JOINS:SQL joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is join and name different type of joins?

974

What are the requirements on sql server network connections?

897

What is difference between temp table and cte?

960

How to grant a permission in ms sql server using "grant execute" statements?

1025

How to insert and update data into a table with "insert" and "update" statements?

917

Differentiate between sql temp table vs table variable?

830

How do use Having,Group by,Group function in SQL?

1692

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1012

What are the basic functions for master, msdb, model, tempdb and resource databases?

938

What is difference between foreign key and unique key?

962

How to name query output columns in ms sql server?

916

What is transactional replication?

903

Can you explain full-text query in sql server?

970

What is master database? : SQL Server Architecture

949

What are secondary xml indexes?

984