Invalid subselect statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I am trying to create a subselect query based on a working query. Basically
I am trying to find computers that do not have a certain windows update
installed. because this update was not a security update, I can't use one of
the standard reports. Below is the query that pulls the computers that have
the update installed. When I try to create a subselect query based off of
this, I get an "Invalid subselect statement". Does anyone know what I am
doing wrong? Thanks!

select SMS_G_System_SYSTEM.Name from SMS_R_System inner join
SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Update for Windows XP
(KB943729)" order by SMS_G_System_SYSTEM.Name
.