What is the difference between inner join @ outer join

Question Posted / karthikeyan2810

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

Can we journel logical file and access path? Can we use commitment control for non-join L.F?

4 Answers

1. If my rpg program has a date field, What extra care I have to take while compiling that RPG program? 2. If the file is keyed and I have declared the file as well as Key list properly in my program. Still am getting an error message like "Chain/reade operation is not allowed" What may be the case?

6 Answers Virtusa,

Whether a module can consists of many procedures or it can consist of subprocedures having a main procedure?If it is possible that it can contain many individual procedures than can we have different name for complete module and how do we call this module in main modul?

3 Answers Steria,

what is the use of sflnxtchg?

0 Answers IBM,

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

3 Answers

what is mean by *MAP and *DROP?what commands use these two keywords?why are they used?

4 Answers

How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"

4 Answers

wat is the difference between dataarea and data queue?

5 Answers Airtel, Four soft, Shahi Exports,

how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.

2 Answers iGate,

I am Submitting one job in batch that job calls three progams(PGMA, PGMB, PGMC). PGMB should be called after sucessfully completion of PGMA as like for PGMC also. So Can you please tell me how can we do that (without using data area)

2 Answers CTS,

suppose i i am changing / updating record of subfile and i want to change the record in reverse order . means i want to change the bottom record first and so on through readc . how i do it please any one explain .

4 Answers CSC,

what is data area and how it is used in rpg program ?

0 Answers IBM,

For more RPG400 Interview Questions Click Here