Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between join and union?
- 4 Answers
- 18782 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / lokesh chauhan
Join is used to established a conditional selection from 2
different tables, while union is used to select similar
data based on different conditions.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What is sqlca?
What is rebind in db2?
Highlight all the advantages that are attached to a package.
What is table space in db2?
What is db2 bind process?
Explain about open switch business continuity software?
What is the usage of open cursor command?
What is database manager in db2?
How do I start db2 in windows?
How many types of page locks can be held in db2?
What is buffer pool in the db2 database?
How do I create a view in db2?
Is db2 free?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
Is it possible using max on a char column?
