Answer / 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.

Answer / saifur rahaman

difference between inner join and outer join is:

inner join means it selects same data only in both the
tables
outer join means first it selects same data and second it
selects different data from the both tables.

Outer Join:

There are three types of outer joins namely:
>>Left Outer Join---For retreiving all the columns from the
first table irrespective of the column match.
>>Right Outer Join---For retreiving all the columns from
the second table irrespective of the column match
>>Full Outer Join---For retreiving all the columns from
both the tables irrespective of column match.

What is the bitwise operator in the sap abap?

0 Answers  

---

What is a collect statement?

0 Answers  

---

What is check table?

0 Answers  

---

What is the full form of "SPA/GPA" Paramaters.

1 Answers  

---

as a developer how u will decided which internal table we will use for requirement?

2 Answers   Accenture,

---

---

What is dialog module?

0 Answers  

---

What are selection texts?

1 Answers  

---

hi i need detailed information on badi and bapi how can this work in real time senarios plz explain with exp

0 Answers  

---

what are the similarities between internal tables and structures?

4 Answers  

---

What are the differences between a database index and a match code? : abap data dictionary

0 Answers  

---

While sorting field groups we cannot use more than one key field. State true or false. : abap modularization

0 Answers  

---

How you can perform field-validation in your dialog program ?

4 Answers   IBM,

---