Interested to Buy Any Domain ? << Click Here >> for more details...
wht is d/f between union and joins ?
- 2 Answers
- 6295 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amarnath reddy
use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;
use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;
| Is This Answer Correct ? | 4 Yes | 1 No |
What techniques will be used to avoid deadlock??
List out the data types available.
What is DB2 (IBM Database 2)?
What is a db2 schema?
How can record locking be achieved in those DB2 versions which do not support it?
where will u check for sqlcode ?
What is the difference between bind and rebind in db2?
Is db2 a programming language?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is blu acceleration in db2?
What is cursor with hold option in db2?
COBOL 
