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.

I have a table with 400 recs. among some are duplicate records. how can I remove the duplicate records from the table. pls help me out.

4 Answers   IBM,

---

Sales Order Information Report that lists information like sales order no, Item no, material no, Quantity, Quantity unit, Net value, Currency,Sub Total, Grand Total. plz mention the detail coding Tahnks, Rahul

0 Answers   TCS,

---

How can we add another field to display in standard SAPSCRIPT? Ex. we have customer address in layout, now we have to add customer Phone no in the same.

3 Answers   HCL,

---

How can end-of-selection be used?

0 Answers  

---

How to write a code for multiple transactions? : abap bdc

0 Answers  

---

i want 2 join as a abap consultant what is most important

3 Answers  

---

What is the Use of LDB PNPCE in ABAP HR? what is NODES statement? I think we have to use GET PERAS event while using PNPCE. Can we use the same using PNP LDB? If yes,how? please give me some example to demonstrate PNPCE?

1 Answers  

---

What is the max no of match code id's that can be defined for one match code object? : abap data dictionary

0 Answers  

---

IF transport where u can create req no for sctipts?

3 Answers   Satyam,

---

what is the standard program to check the consistency of partner profiles?

1 Answers   IBM, Intelligroup,

---

Without writing the event start-of-selection we can execute a report program.Then what's the purpose of writing it?

1 Answers   HP,

---

How to create report in SD open sales order which covers all Organization, delivery status, shipping details and partner function details. plz mention the detail coding Tahnks, Rahul

0 Answers   TCS,

---