join retrive the data more than one table using single sql query where as

what is the difference between join and union?

Question Posted / ananda kumar

Answer Posted / ananda kumar

join retrive the data more than one table using single sql
query where as union combine the results of two or more sql
queries.

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

1056

How can you classify the locks in db2?

1089

How to find the number of rows in db2 tables?

1070

How to compare data between two tables in db2?

1087

What is db2 and what is the use of db2 optimizer?

1064

What is the maximum length of sqlca?

1527

What is cascading rollback?

1213

What is netezza database?

1025

What is null in db2?

1022

What are host variables in db2?

1072

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1277

How to rename a table in DB2 ?

1088

Is db2 a programming language?

1048

What is the role of schema in the db2 database?

1273

Explain various types of locks in db2?

1148