select swm.name "Scanned Manufacturer",
sl.softwarename "Scanned Software",
si.fileversion "Scanned Version",
st.softwaretype "Scanned Software Type",
sc.softwarecategory "Scanned Software Category" FROM softwarelist sl left join softwareinfo si on si.softwareid=sl.softwareid left join softwaremanufacturer swm on swm.swmanufacturerid=sl.swmanufacturerid left join softwaretype st on st.softwaretypeid=sl.softwaretypeid left join softwarecategory sc on sc.softwarecategoryid=sl.softwarecategoryid
GROUP BY si.softwareid,sl.softwarename,si.fileversion,swm.name,st.softwaretype,sc.softwarecategory