What is the difference between inner join @ outer join

Question Posted / karthikeyan2810

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

What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

2 Answers

What are the values of NUM1 and NUM2 after executing the following code? CLONO1NO2NO3 Factorl÷÷+OpcdeFactor2+÷+ResultLenDHHiLoEq C MOVE *LOVAL NUM1 50 C MOVE *J-fIVAL NtJM2 52

2 Answers Fiserv, IBM,

what is the difference between SETON RT & RETURN?

5 Answers

How can i check the object existance in RPG program without using QCMDEXC command.

7 Answers IBM, JDA,

1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400

10 Answers IBM, Tech Mahindra,

How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...

2 Answers

can i use unique key in LF

3 Answers TCS,

How can we change element of compile time array?Can we do so

1 Answers TCS,

You have a *USE authority on a Library and *All authority on a file in that Library.Can you change the data in that file?

1 Answers

Need a sql query: retrieve all duplicate records in table?

1 Answers

1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF

5 Answers

Difference between creating a report using Printer file and WRKQRY(Query Report) ?

3 Answers

For more RPG400 Interview Questions Click Here