Software History

select distinct
    CS.Name0,
    HARP.*
from
    dbo.v_HS_ADD_REMOVE_PROGRAMS HARP
    join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = HARP.ResourceID
    join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = HARP.ResourceID
Where
    HARP.ProdID0 not in (    select
                                ARP2.Prodid0
                            from
                                dbo.v_GS_ADD_REMOVE_PROGRAMS ARP2
                            where
                                ARP2.ResourceID = HARP.ResourceID)