Add/remove programs Query

[AmrelMahdy]

Dears,

I have a program A and Program B , some computers that have Program A installed , some computers have Program B installed , some Computers have A and B installed.

I want to make a Collection for Computers that have program A installed and NOT program B Installed.

I want to make a Collection for Computers that have program B installed and NOT program A Installed

I want to make a Collection for Computers that have program A installed and program B Installed

would you please provide me with the Query for those 3 cases

[GarthMJ]

Each of these are subselect query.

http://smsug.ca/blogs/garth_jones/archive/2007/05/08/subset-query.aspx

http://smsug.ca/blogs/garth_jones/archive/2007/05/10/wql-subset-query.aspx

http://smsug.ca/blogs/garth_jones/archive/2007/05/09/sql-subset-query.aspx