Child pages
  • BEX-OT-ISET-E1
Skip to end of metadata
Go to start of metadata

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.

  • No labels