SELECT systeminfo.workstationname    "Workstation", 
       ( softwarelist.softwarename ) "Software_Name", 
       Max(swmfg.NAME)               "Manufacturer", 
       Max(softwareinfo.fileversion) "Version" FROM   softwareinfo 
       LEFT JOIN softwarelist 
              ON softwareinfo.softwareid = softwarelist.softwareid 
       LEFT JOIN softwaretype 
              ON softwarelist.softwaretypeid = softwaretype.softwaretypeid 
       LEFT JOIN systeminfo 
              ON softwareinfo.workstationid = systeminfo.workstationid 
       LEFT JOIN softwaremanufacturer swmfg 
              ON softwarelist.swmanufacturerid = swmfg.swmanufacturerid 
GROUP  BY systeminfo.workstationname, 
          softwarelist.softwarename 
ORDER  BY 1