oslecat

Olá amigos, não manjo de sql.. tenho essa consulta abaixo, gostaria que ela também verifica-se também add_remove_programs_64_data alguém pode ajudar? SELECT arp.displayname00 AS OfficeEdition , arp.version00 AS OfficeVersion, count(DISTINCT arp.machineid) 'Total' FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey =arp.machineid WHERE ((arp.DisplayName00 LIKE 'Microsoft office%' AND arp.DisplayName00 LIKE '%'+@Version ) AND arp.DisplayName00 not LIKE '%MUI%' AND arp.DisplayName00 NOT LIKE '%Live%' AND arp.DisplayName00 NOT LIKE '%Excel%' AND arp.DisplayName00 NOT LIKE '%powerpoint%' AND arp.DisplayName00 NOT LIKE '%proof%' AND arp.DisplayName00 NOT LIKE '%communicator%' AND arp.DisplayName00 NOT LIKE '%sharepoint%' AND arp.DisplayName00 NOT LIKE '%word%' AND arp.DisplayName00 NOT LIKE '%visual%' AND arp.DisplayName00 NOT LIKE '%visio%' AND arp.DisplayName00 NOT LIKE '%project%' AND arp.DisplayName00 NOT LIKE '%access%' AND arp.DisplayName00 NOT LIKE '%click%' ) AND sys.Client0=1 AND sys.Operating_System_Name_and0 NOT LIKE '%server%' GROUP BY arp.DisplayName00,arp.Version00 ORDER BY 1