query Managed software with contract details

Hi,
I'm trying to track the contractdetails to my managed software list. So far I created a query which gives me the perfect software overview:

SELECT max( SoftwareList.SOFTWARENAME) "Software", max(SoftwareList.DESCRIPTION) "Description", max(SoftwareType.SOFTWARETYPE) "Type", max(SoftwareCategory.SOFTWARECATEGORY) "Category", max(SoftwareList.FILEVENDOR) "Manufacturer", max(SoftwareInfo.FILEVERSION) "Version", max(SoftwareLicenses.LICENSEKEY) "LicenseKey", max(SoftwareLicenses.LICENSETYPE) "LicenseType",COUNT(DISTINCT(SoftwareLicenses.RESOURCEID)) 'Purchased',COUNT(DISTINCT(SoftwareInfo.SOFTWAREINFOID)) 'Installed' ,COUNT(DISTINCT(MaxUsedSwInfo.SOFTWAREINFOID)) 'Max Used' FROM SoftwareGroupMember LEFT JOIN SoftwareList ON SoftwareGroupMember.PARENTSOFTWAREID=SoftwareList.SOFTWAREID LEFT JOIN ComponentDefinitionSoftware ON SoftwareGroupMember.PARENTSOFTWAREID=ComponentDefinitionSoftware.SOFTWAREID LEFT JOIN Resources ON ComponentDefinitionSoftware.COMPONENTID=Resources.COMPONENTID LEFT JOIN SoftwareLicenses ON Resources.RESOURCEID=SoftwareLicenses.RESOURCEID LEFT JOIN SoftwareType ON SoftwareList.SOFTWARETYPEID=SoftwareType.SOFTWARETYPEID LEFT JOIN SWComplianceType ON SoftwareList.SWCOMPLIANCETYPEID=SWComplianceType.SWCOMPLIANCETYPEID LEFT JOIN SoftwareCategory ON SoftwareList.SOFTWARECATEGORYID=SoftwareCategory.SOFTWARECATEGORYID LEFT JOIN SoftwareInfo ON SoftwareGroupMember.SOFTWAREID=SoftwareInfo.SOFTWAREID LEFT JOIN WmiSWUsageInfo ON SoftwareInfo.SOFTWAREINFOID=WmiSWUsageInfo.SOFTWAREINFOID LEFT JOIN MaxUsedSwInfo ON WmiSWUsageInfo.SOFTWAREINFOID=MaxUsedSwInfo.SOFTWAREINFOID where SoftwareType.SOFTWARETYPE = 'Managed' OR SoftwareType.SOFTWARETYPE = 'Freeware' GROUP BY SoftwareGroupMember.PARENTSOFTWAREID ORDER BY 1

I would like to expand the list with the following contractdetails:

contractname, comments, support, maintenancevendor, fromdate and todate

Is this possible?

Thanks for checking this out.