Explain an outer join?
- 1 Answers
- 4732 Views
- I also Faced
- E-Mail Answers
Answer / vamsikrishnamraju
An outer join operation returns all the rows returned by an
inner join plus all the rows from one table that do not
match any row from the other table. An outer join can be
left, right, or full, depending on whether rows from the
left, right, or both tables are retained
| Is This Answer Correct ? | 2 Yes | 0 No |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
wht are the restrictions for union ?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Can you tell me how can you find out the # of rows updated after an update statement?
pls tell me abt the normalization five types....
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is a db2 schema?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
What is an access path?
What is a SELECT statement?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
difference between group clause and order clause
COBOL 
