What is an inner join, and an outer join ?
- 1 Answers
- 12119 Views
- CTA, I also Faced
- E-Mail Answers
Answer / s
Inner Join return only matching rows whereas Outer Join
returns matching rows from both tables and unmatched rows
from either of the table depending on the join.
RIGHT outer Join returns matching rows and unmatched rows
from the right table.
LEFT outer join returns matching rows and unmatched rows
from the left table.
| Is This Answer Correct ? | 27 Yes | 2 No |
What does db2 mean?
How do I import a csv file into db2?
how to get duplicate records from tables?write qurey for this?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
what are bind concepts in db2 cobol?
cobol-db2 runjcl please?
Where is the access path logic created by the DB2 Optimizer stored?
How to find the number of rows in a db2 table?
What is a LIKE table and how is it created?
What is node in db2?
What is scrollable cursor in db2?
Can you use max on a char column?
COBOL 
