Interested to Buy Any Domain ? << Click Here >> for more details...
What is JOIN and different types of JOIN.
- 2 Answers
- 12658 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nidhi sharma
joining of data from two different table by coloums
inner join
outer join
a.left outer join
b.right outer join
c.full outer join
| Is This Answer Correct ? | 26 Yes | 1 No |
Answer / vamsikrishnamraju
Sometimes we have to select data from two or more tables to
make our result complete.
inner join
left join
right join
| Is This Answer Correct ? | 7 Yes | 4 No |
What is the format (internal layout) of ?TIMESTAMP??
What is tablespace?
What is a LIKE table and how is it created?
What is the reason behind not using select * in embedded sql programs?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
define clustering index.
Can SQL statements/queries be included in a copybook?
Could anyone clearly explain the diference between sub query and correlated sub query?
can we update the table by using cursors can anyone post the query?
what is sql abend code -801,-802?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is with ur in db2?
COBOL 
