Which subquery type should be used for mimicking 'NOT IN' as we have Intersect subquery type for IN

Mukta shared this question 2 years ago
Answered

Which subquery type should be used for mimicking 'NOT IN' as we have Intersect subquery type for IN?

Comments (2)

photo
1

Hi Mukta,


The best way to achieve this will be through the "minus" sub-query. Does this work for your use case?


Regards,

Nathan

photo
1

Hi Mukta,

I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!


Regards,

Nathan