What is left outer join?

Answers were Sorted based on User's Feedback



What is left outer join?..

Answer / syam

This is using in SQL
A left outer join will return all the rows that an inner
join returns plus one row for each of the other rows in the
first table that did not have a match in the second table.

Is This Answer Correct ?    7 Yes 0 No

What is left outer join?..

Answer / kapil kumar

We can also use this concept in as400
JDFTVAL is a file level keyword used in Join Logical File.
It also act as left outer join.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

Is it possible to join the same file to itself ?

1 Answers  


is it there an easy way to determine if an html section is available to issue a wrtsection upon?

0 Answers   IBM,


268 How many parameters can be defined in a RPG program. ?

1 Answers  


How to reverse the string in rpg

0 Answers  


Logic cycle

1 Answers  






What is a query can be displayed without saving it?

0 Answers   IBM,


What is the benefit of using Externally Described files over Internally Described?

19 Answers   IBM, Patni,


what does exfmt does?

1 Answers   IBM,


Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?

3 Answers  


What is SFLPAG

1 Answers  


how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?

1 Answers   IBM,


What is the use of Header Specification in RPG/400?

1 Answers  


Categories