Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between join and union?
- 3 Answers
- 11232 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Name and explain the location modes?
Is it possible to obtain a record from IDMS database without mentioning the record-name itself?
Difference between fixed length and variable length records.
What is the meaning of Copy IDMS Subschema-Binds?
What is ook-rec?
How can we debug cobol pgm containig idms using xpeditor?
What is the function of commit in idms?
What is the meaning of the return codes 0307 and 0326?
What is the meaning of copy idms subschema-binds in idms?
How are record locks released?
What is an area sweep and when is it used in idms?
What is the difference between local and central version operating modes?
COBOL 
