what is difference between join and union?

Answer Posted / sunil

JOIN: You can join the 2 tables on tables primary key or on
the filed which refers to another table

UNION: In both table while doing UNION the filed name
should be same.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of Copy IDMS Subschema-Binds?

1201


Explain about logical data model of idms?

515


What is the copy idms subschema-binds?

463


Define a page in idms?

467


What is a run unit in idms?

497






What is a region in idms?

513


What is the difference between local and central version operating modes?

912


What is idms?

501


What is the purpose of store statement?

478


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

507


What is the return codes 0307 and 0326?

509


What is the difference between record occurrence and record type in idms?

468


What is a bind in idms?

450


What is the function of commit in idms?

467


Name and explain the location modes?

501