What is an inner join, and an outer join ?
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 |
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Where is the output of EXPLAIN stored?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
how to identify the pseudo conversation by seeing the program
What information is contained in a SYSCOPY entry?
What does DML stand for and what are some examples of it?
What is a DB2 catalog?
What are some characteristics of columns that benefit from indexes?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
what are bind concepts in db2 cobol?
What is normalization and what are the five normal forms?
What is the database descriptor?