i'm trying to create a query that shows me all the computers that does not have a software package installed. but i get the following error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression
the query look as followed
Code:
Select tblComputers.Computer
From tblComputers
Where tblComputers.Computer != (Select tblComputers.Computer
From tblComputers Inner Join tblsoftware On tblsoftware.ComputerName =
tblComputers.Computername
Where tblsoftware.softwareName = 'Software package that needs to be checked')
the sub query runs fine and gives all the pc's that have the software installed.
i now need a revered list with all the other computers.
the errors message is logical because i get a list. but i'm not sure how to do it else.
