Query working but not as subquery?

Hello,

I am trying to use the blogs from Kent: https://blog.ctglobalservices.com/configuration-manager-sccm/kea/query-to-find-computers-without-net-framework-35-sp1-installed/

with a query:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.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_64.DisplayName like "%System Center Endpoint Protection%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Sophos Endpoint Defense%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%System Center Endpoint Protection%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Sophos Endpoint Defense%"
Blockquote

But I am getting an error:

Any idea?
Thanks,
Dom