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
Code:
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