Skip to Content

How to do reverse of a left outer join in a calculation view

Hi,

I am trying to do what is essentially a reverse of a left outer join in a graphical calculation view. but I am not able to figure out how.

my scenario - I have a table say VBAP. Through some inner joins with other tables , I end with a subset of VBAP Lets call it VBAP_SUBSET.

Now I need to display results which were originally in VBAP but not in VBAP_SUBSET.

or in other words, my result set should be all records that did not satisfy the join condition that I used to define the subset.

primary key of VBAP and VBAP_SUBSET is the same.

So in the picture below, my result should be the blue area.

looking for advice/guidance.

VBAK.png (47.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 23, 2016 at 11:16 PM

    in sql words, wouldnt this be a not in clause?

    so use the main view/table.. .then not in (select from subset ) ??

    or attempt a right join.. and select the conditions which are null... ?? maybe another approach

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.