Select
ARP.DisplayName0,
HARP.InstallDate0
from
dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
dbo.v_HS_ADD_REMOVE_PROGRAMS HARP
Where
ARP.ResourceID = HARP.ResourceID
and ARP.ProdID0 = HARP.ProdID0
Group by
ARP.DisplayName0,
ARP.InstallDate0,
HARP.InstallDate0
Having
isnull(ARP.InstallDate0,’1980-1-1′) <> Min(isnull(HARP.InstallDate0,’1980-1-1′))
Order by
ARP.DisplayName0,
HARP.InstallDate0