what is the difference between join and union?
Answer Posted / suresh ramaiyan
Join is used retrive the data from two or more tables.
Union is used to join the result of two queries.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is the maximum length of sqlca?
what is db2 restart?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is access path in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to test SQL -911 error while developing COB-DB2 program
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Can we update view in db2?
What is db2 bind?
What are the uses of db2 optimizer?
What is meant by dclgen?
What is the clustering index in the db2 database?
What is the difference between using bind () and rebind () methods of naming class?
What is database manager in db2?
What does db2 blu stand for?