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 role of ST05 in performance tuning?

2 Answers  

---

What does a lock object involve?

0 Answers  

---

i have 4 primary keys and i want to use only one primary key for select single.What changes will occur in the system?can i use it?

4 Answers   Siemens,

---

To how many tables can an append structure be assigned. : abap data dictionary

0 Answers  

---

how to make split command reusable?

0 Answers  

---

---

What is LDB?

4 Answers  

---

A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?

0 Answers  

---

The structure of a table has been changed in the ABAP/4 Dictionary. Which of the following adjustments in the relevant database table is correct, if you want to retain the previous data?

1 Answers  

---

what is the main difference between headerline and workarea??

3 Answers  

---

What take most time in SAP Script programming?

2 Answers   Wipro,

---

What is the difference between call transaction method and the session method? : abap bdc

0 Answers  

---

what all we can see in TMG? what is its use?

1 Answers   IBM,

---