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
What is pnp-sw-found ? : abap hr
what is the difference between hashed & sorted internal tables?
How can end-of-selection be used?
Which infotype records can not be deleted ? : abap hr
What are secondary indexes. How can we know which index is being used in a select query?
Example of table cluster and cluster tables.
What is the function of the correction system?
What are the two different ways of building a match code object?
What is a matchcode?
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
Update types in Call transaction method. What is the difference?
What are the events in abap/4 language? : abap hr
When the top-of-page event does get triggered?
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
