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