Jump to content


rwakefie

Established Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About rwakefie

  • Rank
    Newbie
  1. Hello, I have two queries that i need to combine to get all systems that do not have the client installed and are windows 7 systems, I have the two queries but i do not know how to combine them. I have seen people using INTER JOIN but i do not know how to use it. Here are my two queries All systems with out a client 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 where SMS_R_System.ResourceId not in (select SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.Client = 1) All Windows 7 Systems 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 where OperatingSystemNameandVersion like '%Workstation 6.1.7600' I sure this is not that difficult but any help would be greatly appreciated. Thanks
×
×
  • Create New...