what is the difference between join and union?

Answer Posted / suresh ramaiyan

Join is used retrive the data from two or more tables.
Union is used to join the result of two queries.

Is This Answer Correct ?    7 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

719


What is explain plan in db2?

592


Explain the contention situations caused by locks?

592


What is reorg and runstats in db2?

696


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

714






What is catalog database in db2?

646


How do I create a view in db2?

606


Is db2 a programming language?

606


define clustering index.

618


What is difference between alias and synonym in db2?

645


Where can you declare a cursor in a cobol-db2 program?

604


How does cobol compile db2 program?

610


What do you mean by cursor?

586


What is a cursor in programming?

596


What is load utility in db2?

668