Opposite of Inner Join

[Black_Hole]

Hello All,

Please could you tell me if there is a functionality which is the opposite of INNER JOIN ?

I already tried the functionality OUTER JOIN, but the result is not as expected.

Thank you in advance for your help.

[Brett_Bleess]

Have a look at the following specific Design Blog post to see if it may help:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

Here is the base URL for the Design Blog area as well in case you want to search further for other posts, and here is Help link on Joins after that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/combi...

Hopefully those will get you what you need.

Regards,
Brett

[lorenzoconforti · Accepted solution]

Are you looking for an anti join? Both right and left?

in that case you just need to create an inner join then load back both tables with a where clause not exists

https://community.qlik.com/t5/QlikView-App-Development/Load-an-outer-excluding-join/td-p/745677

Lorenzo

[Black_Hole]

Hello @lorenzoconforti, @Brett_Bleess ,

Many thanks for sharing the links.

For the moment I tried the solution using an inner join and then a clause Where not exists.

And this solution gives me the result expected. 👍