Help on use of minus set command
Hi everyone,
I have a challenge using minus to eliminate one-for-one occurence of records between 2 tables. The second table can contain duplicate entries.
What I want is - for every single record in table 1, I want to minus a single occurrence of the same record in table 2 even if there are 2 or more of that record in table 2.
I will appreciate any form of guidance.
Thanks