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 write dml inside a function in sql server?

957

What do you understand by case manipulation functions?

1036

How many developers work on postgresql?

986

How to avoid duplicate records in a query?

1009

What is thread join () in threading?

1018

What do you mean by query optimization?

1006

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1074

Why do we use view in sql?

970

Why is sql important?

1113

How many types of primary keys are there?

1040

What does fetching a cursor do?

1094

What is latest version of sql?

1048

What is the difference between truncate and drop statements?

1191

What is the syntax to add a record to a table?

1090