Answer Posted / apoorv sharma
You use INNER JOIN to return all rows from both tables where
there is a match. ie. in the resulting table all the rows
and colums will have values.
In OUTER JOIN the resulting table may have empty colums.
Outer join may be either LEFT or RIGHT
LEFT OUTER JOIN returns all the rows from the first table,
even if there are no matches in the second table.
RIGHT OUTER JOIN returns all the rows from the second table,
even if there are no matches in the first table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to do find it?
Difference between Insert, Update and Modify?
What are the types of records that are transferred to sap r/3 and used by interfaces? : abap bdc
Suppose there is check box along with the rows. The requirement is, select the require check boxes and press a used defined button to save all these checked row data to another table. How can you do it?
how to create view in bdc..??
Lock objects and what are parameters of ENQUEUE FM?
how to use the xk01 in realtime.can it apply the others. how it it will goes to first page and next page.
While using extract datasets it is required to have a special workarea for interface. State true or false. : abap modularization
What does the ‘suppress dialog’ do?
Event handling in oops
What are the parameter types for a method?
What is open sql vs native sql ?
In sap script how to print bar code in vertical manner
visibility section for class level and attributes level
What is an abap?