SELECT (SoftwareList.SOFTWARENAME) "Software_Name",

MAX(aaov.NAME) "Site",

MAX(SystemInfo.WORKSTATIONNAME) "Workstation" 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 Resources resource ON systeminfo.WORKSTATIONID=resource.RESOURCEID

LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID

LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID

LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID

 where SoftwareList.SOFTWARENAME like '%Warp%' GROUP BY SoftwareList.SOFTWARENAME,SystemInfo.WORKSTATIONNAME ORDER BY 2

 

This is the result

Software_Name	Workstation
	Alpine

I'd like to pull in Department, Location and Notes

Software_Name	Workstation	Department      Location            Notes
	Alpine