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

Can we edit a view in sql?

983

Is left join faster than join?

1050

How can you create an empty table from an existing table?

1079

What are all the common sql functions?

1017

What is cost in sql execution plan?

981

What is cursor and why it is required?

1180

explain the difference between delete , truncate and drop commands? : Sql dba

1092

How do I create an index in word?

1029

What is sql deadlock?

1134

how do you know if your mysql server is alive? : Sql dba

1078

Is a secondary key the same as a foreign key?

1036

How to make a copy values from one column to another in sql?

1035

How to install oracle sql developer?

1042

Define join and name different types of joins?

1008

What can you do with pl sql?

1093