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 does a store statement do?

1113


What is a bind in idms?

446


Define autostatus in idms?

484


Name and explain the three location modes?

1013


Explain about run unit currency?

507






What is a set? How may sets be ordered?

468


What is meant by idd in idms?

474


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

519


What is the copy idms subschema-binds?

461


Explain the difference between record occurrence and record type?

1659


What is the function of rollback in idms?

518


When an area sweep is used?

444


Name and explain the location modes?

498


What is ook-rec?

532


What does a finish do in idms?

517