SQVI - table connections
This question might be very primitive to you, but I don't know the answer, so I'd like you to help me.
If the jointtype is <i>'left outer'</i> I can list all record from the 'left' table even if it doesn't have its counterpart (suitable record) in the 'right' table.
But if I connect one more table to the 'right' one, I cannot get all record from the 'left' table - I can't get those that don't have their counterpart in the 'left'.
MAST_1 - STKO - STPO - (Left outer ) - MAST_2
All children part (components) will be listed from STPO. But if I connect STKO_2 and STPO_2 to MAST_2 (in order to get the 2 level components) those components that don't have their suitable record in MAST2 will disappear.
parent children_1level children_2level
The query won't display B because B doesn't have BOM.
How can this iisue be solved (in SQVI - I can't use ABAP).
Please help me!