Join is used to MERGE the data from 2 or more different tables, while uni

What is the difference between join and union.

Question Posted / rupesh singh

Answer Posted / rupesh singh

Join is used to MERGE the data from 2 or more different
tables, while union is used to APPEND the data based on
different conditions.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are data types in pl sql?

1075

How many types of cursors are available in pl/sql?

1041

Why do we use partitions in sql?

975

Explain the difference between 'between' & 'and' operators in sql

945

what is data manipulation language? : Sql dba

945

What is the purpose of my sql?

899

What is schema in sql example?

1087

Can we use two order by clause in query?

918

What is compilation error in pl sql?

920

How do I view a sql database?

982

What are pl/sql packages?

1035

how to convert numeric values to character strings? : Sql dba

1034

how can I make a script that can be bi-language (supports english, german)? : Sql dba

941

What is cursor explain with example?

921

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

984