List Computers without specific software

[sinky]

Hi,
i need an SQL Query for all Computers, that have not installed .NET Framework 4.
In case i use "Where <table> Not Like '%framework 4 client%'", i get every software that's not .NET Framework 4.
But i need a list of Computers wich have no .NET

Thanks folks

[sinky]

Yeah, thank you very much for your help.

[Hemoco · Accepted solution]

This is the full sql:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
From tblsoftware Where tblsoftware.softwareName Like '%framework 4 client%')

[Hemoco]

you need to specify the where clause like this

where tblcomputers.computername not in (select computername from tblsoftware where sofwarename like '%framework 4 client%')

[sinky]

Lansweeper wrote:
you need to specify the where clause like this

where tblcomputers.computername not in (select computername from tblsoftware where sofwarename like '%framework 4 client%')

Thanks for your Reply. But your Code doesn't work or me.
Im not very good with SQL 😉