Skip to content
Advertisement

How to rewrite query NOT IN with join condition

Below query having high cost, dur to NOT IN (sub-query)

I dont have idea how to rewrite the AND clm.column1 NOT IN(sELECT column1 FROM prod) with join condition.

If have any idea, please let me know.

Advertisement

Answer

There are multiple issues in your query. I tried to resolve them as much as possible in following code:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement