K
Kevin
I have two tables. One that has ComputerID and some other fields. The
ComputerID field is unique. I also have another table that has a non-unique
Computer ID field and a SWName record for each software program installed
on that computer. What I would like to do is find out what ComputerIDs DO
NOT have a specific program (ProgramA). I was thinking I would get what I
needed if I could take the results for those ComputerIDs that DO have
ProgramA and compare that with all of the ComputerIDs possible and take the
difference. Is there some way to do this? If not, what would I have to add
to one, the other, or both tables to get what I need?
Thank you.
Kevin
ComputerID field is unique. I also have another table that has a non-unique
Computer ID field and a SWName record for each software program installed
on that computer. What I would like to do is find out what ComputerIDs DO
NOT have a specific program (ProgramA). I was thinking I would get what I
needed if I could take the results for those ComputerIDs that DO have
ProgramA and compare that with all of the ComputerIDs possible and take the
difference. Is there some way to do this? If not, what would I have to add
to one, the other, or both tables to get what I need?
Thank you.
Kevin