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 are tokens?

4 Answers   Satyam,

---

Explain what is the difference between sy-tabix and sy-index? Where it is used?

0 Answers  

---

CAN ANY BODY TELL ME IN A COMPANY HOW BAPI WORK WILL GOES? WHO WILL TELL WHICH BAPI WILL SET FOR THE PRESENT REQUIRENT?

1 Answers  

---

By default SAP provides locking mechanism if db is being used by a user ,then what is the use of writing enque method in your code?

1 Answers   SAP Labs,

---

I have two selection screens, i gave values in first selection screen but i din't give any values in second screen. will it display or not plz tell me?

2 Answers  

---

Application Category?

0 Answers   Infosys,

---

difference between at selection-screen and at selection-screen output?

4 Answers   MGL, Siemens,

---

what is the code for basic list to 2ndry list?

1 Answers  

---

What is the difference between Initialization and parameters ?

1 Answers  

---

what r the services have to implemented in SAP R/3?

1 Answers   HCL,

---

What is an internal table?

0 Answers  

---

What is a database view? : abap data dictionary

0 Answers  

---