Interested to Buy Any Domain ? << Click Here >> for more details...
What is left outer join?
- 2 Answers
- 9627 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / syam
This is using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kapil kumar
We can also use this concept in as400
JDFTVAL is a file level keyword used in Join Logical File.
It also act as left outer join.
| Is This Answer Correct ? | 5 Yes | 0 No |
what is service program?
what is a keyed physical file?
define what a data area is along with a brief example of what it may be used for?
how you will find an error which is not in the first page of the subfile without using rolldown key?
at what level s,o are defined and what they will do?
Describe about Query/400?
How can you identify End of file in CLP program?
Which of the following operations does NOT zero the field FLDA defined as 4,0? C MOVE *ZEROS FLDA C Z-ADD *ZEROS FLDA C Z-ADD 0 FLDA C MOVE *ALL'0' FLDA C SUB FLDA FLDA C MOVE '0000' FLDA C CLEAR FLDA C MOVE *BLANKS FLDA
What are the two main attributes, which govern the execution of a job?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
Can fields be concatenated INa logical file level?
what is procedure prototype and procedure interface.
RPG400 
