what is the difference between join and union?

Answer Posted / lokesh chauhan

Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.

Is This Answer Correct ?    7 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rct?

752


Can one database have multiple instances?

583


Is db2 a mainframe?

589


What is db2 connect?

609


What is performance tuning db2?

620






How to rename a table in DB2 ?

641


How to find schema of a table in db2?

572


What is bufferpool in db2?

580


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

751


What do you mean by cursor?

586


List out the buffer pools in db2

632


How do I delete a table in db2?

651


What is an instance in db2?

563


Define check constraint.

644


What is the purpose of using commit?

618