what is difference between join and union?

Answer Posted / rajeev singh

Join display exact information from two or more tables.
and it is not compulsory in both table column equal.

Where as in UNION in both table column should be equal.
and union eliminate the dublicate rows.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is idms?

501


What does a store statement do?

1117


Explain about area currency?

501


What is the difference between fixed length and variable length records?

524


Does Disconnect and Connect creates page lock in IDMS ?

1022






What is an OOK-Rec?

1223


What is the advantages of using IDMS compared to other database systems?

996


What is the copy idms subschema-binds?

463


Difference between fixed length and variable length records.

499


Explain the difference between a schema and a subschema in idms?

443


What is a set? What pointers are required, what are possible? How may sets be ordered?

980


What is an area sweep and when is it used?

1082


Explain the difference between record occurrence and record type in idms?

502


what methods are available for persisting records in an idms database?

471


Is there a application program coding difference between local and central version mode in idms?

485