Interested to Buy Any Domain ? << Click Here >> for more details...
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
foreign key enforcement?
What are the fields in the memory table ‘screen’?
What functions does a data dictionary perform? : abap data dictionary
What are the main uses of the primary key?
what are Hana Basics
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?
How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization
What are the user interfaces of interactive lists?
How does the interection between the dynpro and the abap/4 modules takes place?
What is a 'z' report?
how to Implement a BADI in which it restricts the access when purchase order is created against contract using definition ME_PURCHDOC_POSTED. please tell me the answers if any one knows. thanks in advance. :ravikiran
Can you show multiple alvs on a single screen?
What is a subroutine?
Polymorphism real time scenario
Which table stores the programs created?
