What is the difference between inner join @ outer join

Question Posted / karthikeyan2810

4 Answers
9790 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

1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?

1 Answers NetCracker,

why we do STRSRVJOB in batch debugging in as400

1 Answers

How to update only a field of a PF in an RPG program. I don't want to update the record, only one field.

2 Answers

How can we know running job is batch or interactive?

0 Answers

Delete FileName at first statement in RPG.

1 Answers

Suppose i am having 3 programs PgmA,pgmB,pgmC and using source debugger. At debugging time i found that pgmC having some code error..then in debug mode directly how can i debug pgmC

2 Answers

1.Where we declare Variables in RPG/400,RPGIV,RPGILE.? 2.When do we use D-spec and I-spec in real time ?.what is difference between them?

1 Answers HP,

wat is curser?? and its types???

4 Answers HSBC,

am 2010 passed out . can any one tell me which course is good to put 2+fake .guide me

1 Answers

2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed

2 Answers IBM,

1.Can any body share me about thease opcodes with example please.Im new for AS/400.Could u please tell me in real senario? 1.TESTN, 2.EVAL 3.EVALR, TIME, 4.MONITOR 5. ENDMON 6.ON-ERROR 7.COMMIT ROLLBACK?

1 Answers CSC,

What are the commands that can be executed in CLP but not in RPG? Why?

1 Answers CSC,

For more RPG400 Interview Questions Click Here