Help updating this report

[poweld1]

Can I have some help adding in the operating system version for the following report.

Select Top 1000000 upgrade_tblComputers.Computername,
  upgrade_tblComputers.ComputerUnique,
  upgrade_web40AllIPLocations.IPLocation,
  upgrade_tblComputers.Username,
  upgrade_tblComputers.LastknownIP,
  upgrade_tblSoftware.Lastchanged
From upgrade_tblSoftware
  Inner Join upgrade_tblComputers On upgrade_tblSoftware.ComputerName =
    upgrade_tblComputers.Computername
  Left Join upgrade_web40AllIPLocations
    On upgrade_web40AllIPLocations.Computername =
    upgrade_tblComputers.Computername
Where (upgrade_tblSoftware.softwareName = 'BDE 5.11 for SIMS Workstation Setup')
  Or
  (upgrade_tblSoftware.softwareName = 'SIMS Infrastructure')
Group By upgrade_tblComputers.Computername,
  upgrade_tblComputers.ComputerUnique,
  upgrade_web40AllIPLocations.IPLocation,
  upgrade_tblComputers.Username,
  upgrade_tblComputers.LastknownIP,
  upgrade_tblSoftware.Lastchanged,
  upgrade_tblSoftware.softwareVersion,
  upgrade_tblSoftware.SoftwarePublisher
Order By upgrade_web40AllIPLocations.IPLocation,
  upgrade_tblComputers.ComputerUnique,
  Count(upgrade_tblSoftware.ComputerName) Desc

[Hemoco · Accepted solution]

You need to add upgrade_tblOperatingsystem.Caption to your report. Link upgrade_tblOperatingsystem to upgrade_tblComputers on the Computername field.