infoset demo

8/3/2019 Infoset Demo

1/14

MATNUM DOCNUM ITEMTYPE SALRY

100001 120001 A 2

100002 120001 B 3

100003 120003 C 4

100004 120004 D 5100002 120001 B 6

100002 120001 B 3

100003 120001 C 4

OUTPUT of DSO1

Scenerio 1:

DSO1

Inner join vs Inner join


2/14

Scenerio 2:

Scenerio 3: outer vs innsr join

Scenerio 4:

Inner join vs Outer join


3/14


4/14

MATNUM DOCNUM ITEMSTATITEMTYPEQUANTITY

100001 120001 DEL A 2

100002 120002 DEL B 3

100003 120003 DEL C 4

100004 120004 PEN D 5100005 120004 PEN B 6

100006 120005 PRO B 3

100007 120004 PRO C 4

OUTPUT of DSO2

DSO2


5/14

Outer join Outer Join not


6/14


7/14


8/14

ossible


9/14

Scenerio 1:

Scenerio 2:

Scenerio 3: Outer join vs Outer join

Inner join vs Outer join

Inner join vs Inner join


10/14

Scenerio 4:


11/14


12/14

Outer join Outer Join not possibl


13/14


14/14

infoset demo

Documents