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

Which are the different case manipulation functions in sql?

1077

Define tables and fields in a database

1177

Why is partition used in sql?

1182

What is the difference between delete and truncate commands?

1098

How to run pl/sql statements in sql*plus?

1146

How is a PL/SQL code compiled?

1283

Why are sql stored procedures used?

1095

what is rdbms? : Sql dba

1064

Why primary key is required?

1043

What is the difference between partitioning and sharding?

1050

Is not equal in sql?

1062

How to revise and re-run the last sql command?

1218

How sql query is executed?

1187

What is string join?

1025

explain about mysql and its features. : Sql dba

1053