An InfoSet contains the DSO object ‚Sales‘ and the InfoObject ‚Customer‘:
(I) Inner Join
Inner Join between these tables regarding the field customer
DSO:
Year | County | Customer | Sales |
|---|---|---|---|
2003 | AT | 101 | 10 EUR |
2004 | AT | 101 | 20 EUR |
InfoObject:
Customer | Account Gr. | City Code | Name |
|---|---|---|---|
101 | A | 1010 | Miller |
102 | B | 1020 | Mare |
103 | B | 3040 | Ligerty |
InfoSet:
Customer | Account Gr. | Year | Sales |
|---|---|---|---|
101 | A | 2003 | 10 EUR |
101 | A | 2004 | 20 EUR |
Only the customers which exist in both tables can be found in the result set.
(II) Left Outer Join
Left outer join between the Infoobject and the DSO (again regarding the field Customer). The DSO is the so called right operand and is highlighted (lighter shade). See also note 577953.
InfoSet:
Customer | Account Gr. | Year | Sales |
|---|---|---|---|
101 | A | 2003 | 10 EUR |
101 | A | 2004 | 20 EUR |
102 | B | ||
103 | B |
Please note that we now have 2 data records (customers 102 and 103) in the result set where the corresponding customers don't exist at all in the DSO.