When I run this query I have about 10000 records
Select DISTINCT NetBios_Name0, DisplayName0, Version0
From v_Add_Remove_Programs arp
join v_R_System sys on arp.Resourceid = sys.resourceid
--full join v_GS_SoftwareFile SF on SYS.ResourceID = SF.ResourceID
Where DisplayName0 like '%Google Chrome%'
When I run this query I have about 7000 records
Select DISTINCT NetBios_Name0, DisplayName0, Version0, SF.FileName, SF.FileDescription, SF.FileVersion
From v_Add_Remove_Programs arp
join v_R_System sys on arp.Resourceid = sys.resourceid
full join v_GS_SoftwareFile SF on SYS.ResourceID = SF.ResourceID
Where DisplayName0 like '%Google Chrome%' and SF.FileName like 'Chrome.exe%'
Is there a way to run the first query where it will show me all 10000 records and just fill in the information for SF.FileName, SF.FileDescription, SF.FileVersion if it exist and leave it blank
if it does not.
Thanks
Any Help will be highly appreciated.
