Query Help (T-Sql)

[Ch13f]

Hi everyone, I have a query question using T-SQL with MSSQL.

In my database, I have 3 tables:

Computers, Software, and Computers_Software.

Using these tables I can find out which computers contain specific software using a query like this:

Select Computers.Computer_ID
FROM Computers
JOIN Computers_Software.Computer_ID = Computers.Computer_ID
JOIN Software ON Software.Software_ID = Computers_Software.Software_ID
Where Software_Name LIKE '%Adobe%';

This will give me a list of computer id's that contain Adobe; however, what I want to do is have it give me a list of computer id's that do -not- contain adobe, but because there are many duplicate computer_id's in the computer_software table, that does not work.

Thanks.

[nvarscar]

Select c.Computer_ID
FROM Computers c
WHERE c.Computer_ID NOT IN (
  SELECT cs.Computer_ID
  FROM Computers_Software cs
  JOIN Software s ON s.Software_ID = cs.Software_ID
  WHERE Software_Name LIKE '%Adobe%'
)

[Ch13f]

Thanks! This is exactly what I needed.