What is the difference between inner join @ outer join
- 4 Answers
- 8360 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to select highest score of each subject or how to select highest income of every month?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
How Chain operation copies the record's data to the input buffer for the program?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
How can we know running job is batch or interactive?
how do I declare a table or array in rpg iv?
How many program bind in one module....
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
How can we override a file during runtime in rpg?
what is the procedure and explain about real time scenario.
can I touch the array during treatments?
When it is desirable to describe files Internally?
What is the difference between iter and do?
