Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
  tblSoftware.softwareName As Software, tblSoftware.softwareVersion As Version
From tblSoftware Inner Join
  tblComputers On tblSoftware.ComputerName = tblComputers.Computername
Where tblSoftware.softwareName Like '%Acrobat %'
Order By tblSoftware.softwareVersion, tblComputers.ComputerUnique