What is the difference between join and union.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain foreign key in sql?

619


Is pl sql useful?

536


Is sqlite good enough for production?

527


What are the types of subqueries?

568


Which table is left in left join?

516






Is foreign key mandatory?

550


What is not null in sql?

568


Is ms sql traffic encrypted?

497


What is dense_rank?

530


what does the t-sql command ident_incr does? : Transact sql

591


How do you remove duplicates without using distinct in sql?

499


Mention what are different methods to trace the pl/sql code?

554


what are myisam tables? : Sql dba

541


What is pl sql commands?

553


What are the types of index in sql?

528