Workaround for MINUS (with Where)

[Autoclave]

Hello, I found myself in a situation that I need a workaround for the missing MINUS operator in ACCESS.

I'll explain in detail:
Partners vs Tags.
N:N relationship (One partner can have multiple tags, one tag can be assigned to multiple partners.

I have the following tables:
tblPartners with PartnerID as Primary key
tblTags with TagID as Primary Key
junction table: tblPartner_Tag with PartnerID and TagID as primary keys.

Now I need to get a list of partners that that DO NOT have a specific tag.

I imagine that the SQL for this (sorry if it has mistakes) should be like this

SELECT tblPartners.PartnerID, tblPartners.PName
FROM tblPartners

MINUS

SELECT tblPartners.PartnerID, tblPartners.PName
FROM tblPartners INNER JOIN tblPartner_Tag ON tblPartners.PartnerID = tblPartner_Tag.PartnerID 
WHERE (((tblPartner_Tag.TagID)= 100));

how do I implement this?
Please keep in mind that this will be a assigned to a combox.rowsource dynamically (might be different TagID, so I cannot solve this with unmatched query wizard..)

Thank you very much for any help

[Autoclave]

I found the solution with Not In

SELECT tblPartners.PartnerID, tblPartners.PName
FROM tblPartners
Where PartnerID not in (
SELECT tblPartners.PartnerID
FROM tblPartners INNER JOIN tblPartner_Tag ON tblPartners.PartnerID = tblPartner_Tag.PartnerID 
WHERE (((tblPartner_Tag.TagID)= 100)));

Is this the most efficient way? to solve this?

[orange]

Another method

SELECT PartnerID, PName
FROM tblPartners
Where NOT EXISTS
(
SELECT *
FROM tblPartner_Tag
WHERE tblPartners.PartnerID = PartnerTag.PartnerID
AND PartnerTag.PartnerID= 100
);