[Solved] SQL Join creating duplication in output [closed]

Question

So I solved this myself by using a Sub-query.

The nature of the the requirement meant that it was difficult for me to produce a list which eliminated the duplicates, because i was looking in a joined table for results which may or may not appear.

So i used a sub-query in the where clause to look for the the instances where what i was trying to exclude which was producing the false positives did appear and use the use those results to eliminate those primary keys from the original table that way using a Not In Primary Key.

Probably not the most efficient but it does work within a couple of seconds

Accepted Answer

So I solved this myself by using a Sub-query.

The nature of the the requirement meant that it was difficult for me to produce a list which eliminated the duplicates, because i was looking in a joined table for results which may or may not appear.

So i used a sub-query in the where clause to look for the the instances where what i was trying to exclude which was producing the false positives did appear and use the use those results to eliminate those primary keys from the original table that way using a Not In Primary Key.

Probably not the most efficient but it does work within a couple of seconds