What is the difference between inner join @ outer join

Question Posted / karthikeyan2810

4 Answers
10018 Views
I also Faced
E-Mail Answers

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

I have two sessions S1 & S2 under this 3 jobs(say j1,j2,j3 under session S1) And 2 jobs(Say j4, j5 Under session S2)is running. How many QTEMP & how many LDA will create for the same.

9 Answers IBM,

We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

0 Answers

Anybody can explain the difference between SFLCLR & SFLINZ?

7 Answers

To check the locks , we use cmd WRKOBJLCK , but how we confirm whether it's objeck lock / member lock. I confused with the Lock type and Status values...Can any body please tell me ...

5 Answers

1.What is referential Integrity? 2.What is Foreign Key? 3.What is Transfer Control? 4.What is Free format?

3 Answers

How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

0 Answers

suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis

1 Answers

Maximum how many files declare in rpgle

3 Answers TCS,

what is the difference between do while and do until?

0 Answers IBM,

1.The questions have given an array declaration and move operation then this statement is correct or not?

3 Answers TCS,

Hi friends, Can you give the solution for the below mention simple code.and explain.what is output D CHR1 S 4A INZ('PEN') D CHR2 S 10A INZ('MYGET') D CHR3 S 8A INZ('GOOD') D CHR4 S 22A INZ C MOVEL CHR1 CHR4 C MOVE CHR2 CHR4 C EVAL CHR4=CHR3 C MOVE CHR1 CHR4

4 Answers

what happens when sflsiz = sflpag? What are the advantages and disadvantages?

0 Answers IBM,

For more RPG400 Interview Questions Click Here