what is difference between join and union?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / harish
JOIN: column wise joining of data.....
UNIOn: row wise joining of data........
Harish poomgame shivappa
NIIT Technolgies
Kolkata
Is This Answer Correct ? | 8 Yes | 9 No |
What is auto status?
Define autostatus in idms?
when you will get abend U0077?
What does a ROLLBACK do?
Distinguish among erase, erase permanent, erase selective and erase all?
What is ook-rec?
What are storage attributes of records?
What is dbkey?
Explain the difference between record occurrence and record type?
Is it possible to obtain a record from IDMS database without mentioning the record-name itself?
What is a set in idms?
What is the advantages of using IDMS compared to other database systems?