Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between inner join @ outer join
- 4 Answers
- 10180 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi shankar porwal
In inner join only matched records of primary & secondary
will be selected.Whereas in outer join All the records of
primary file get selected with default value of secondary
file.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ravi shankar porwal
In inner join only matched records of primary & secondary
will be selected.Whereas in outer join All the records of
primary file get selected with default value of secondary
file.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mathan kumar
inner join means join the file it self...
outer join means join the primary file with secondary
file..
| Is This Answer Correct ? | 0 Yes | 5 No |
why we do STRSRVJOB in batch debugging in as400
what is estimation? and what is the level identifier parameter in PF?
i have a file with the values 10, 20, 30, 40, if am setll with the value 25 then readp, so what it will return?
HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?
1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword
How to print Superscript / Subscript from RPG400
How to index LF by relative record no (RRN)
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?
What is the name of default out queue when user logs inn to syatem with valid profile?
In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?
1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.
what is the difference between SETON RT & RETURN?
RPG400 
