Answer Posted / 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 |
Post New Answer View All Answers
How to avoid using indicators in ile ?
what is the purpose of putovr (put with explicit override) keyword?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
during input operation which indicator position is seton if there is a record lock?
what is the maximum number of record formats in dspf?
what is subfile?
how many specifications are there in rpg/400? What are they?
What is access path in as400?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
what is a composite key?
if we tried to move year part of *iso date into a field of length 3, what will happen ?
What is file access opcodes?
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
what is the difference between normal upddta to pf and updating using dfu program?
what is the purpose of ovrdta and ovrata keywords ?