Query to compare data

[Guest]

I have one table that lists all of the hotfixes that are supposed to be on
our computers and a SQL query that gives me the PC name and each patch that
has been applied to it. I'd like to have a query check the master list of
hotfixes against the hotfixes that have been applied to return any patches a
PC is missing. Can this be done?

 

[Marshall Barton]

I have one table that lists all of the hotfixes that are supposed to be on
our computers and a SQL query that gives me the PC name and each patch that
has been applied to it. I'd like to have a query check the master list of
hotfixes against the hotfixes that have been applied to return any patches a
PC is missing.

Create a new query using the Find Unmatched Query wizard.

 

[[MVP] S.Clark]

I'm assuming that there exists another table that stores just PC's, then one
more table that stores the hotfix number and date applied.

Given this, you would solve by the inverse. Exclude all PC's that DO have
the fix you're looking for, which will leave you with those that DON'T.

Otherwise, you have to do some set theory - Venn diagram stuff, and ya don't
wanna go there.

 

[Guest]

you could use a set difference..this uses the EXISTS predicate in Access...