What is the difference between inner join @ outer join

Answers were Sorted based on User's Feedback



What is the difference between inner join @ outer join..

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

What is the difference between inner join @ outer join..

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

What is the difference between inner join @ outer join..

Answer / kamal

In inner join means matching records in b/w the joining file will be selected.

Outer join means all records from primary file and matching records from secondary.

Is This Answer Correct ?    1 Yes 1 No

What is the difference between inner join @ outer join..

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

Post New Answer

More RPG400 Interview Questions

Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20

5 Answers  


how do u find whether a record is locked or not??/

5 Answers   CTS,


how to retrieve RRN value in RPGLE program

3 Answers  


Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

0 Answers  


How to create a key field for a logical file inside RPG?

4 Answers   HSBC,






How can read PF in reverse order (end to start) in CL pgm..

8 Answers   TCS,


How do I read records from Subfile? what is the purpose of READC explain with example?

4 Answers   IBM,


I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic

2 Answers  


How to handle duplicate error handling in RPG?

0 Answers  


what is EXCEPT command in rpg and use

1 Answers   Active Brains,


i)What is the command to lock a file in a program ii)2. Can you get a level check error in a CL program

6 Answers  


Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?

3 Answers   IBM,


Categories