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 difference between user exit, customer exit and badi?

1 Answers  

---

give the all step of workflow process step by step

1 Answers   HCL,

---

How to read files and process BDC's automatically ?

0 Answers  

---

What are client dependent objects in abap/sap?

0 Answers  

---

How can you call a page explicitly in smart forms?

1 Answers  

---

suppose you are using session method for 1000 records and there is error in 400 and 500 records.how many records will be updated to the database?

3 Answers  

---

Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?

0 Answers  

---

How to handle errors in call transaction bdc method without using bdcmsgcoll internal table? : abap bdc

0 Answers  

---

How To Debug Ale ....

3 Answers   Accenture,

---

what is ment by buffering?

1 Answers   Accenture,

---

what is the unit of work

2 Answers   IBM,

---

What is the Difference Between basic list and interactive list?

5 Answers   Satyam,

---