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

Does Disconnect and Connect creates page lock in IDMS ?

1029


Distinguish among erase, erase permanent, erase selective and erase all?

1226


What does a finish do in idms?

534


What does a store statement do?

1123


What is the meaning of Copy IDMS Subschema-Binds?

1205






How can we debug cobol pgm containig idms using xpeditor?

1166


What is dbkey?

523


What is an OOK-Rec?

1223


Name and explain the three location modes?

1025


What methods are available for persisting records in an idms database? Explain.

487


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

505


Explain about find and obtain commands?

546


What is a page in idms?

508


How may sets be ordered?

511


When an area sweep is used?

456