Reference Software Audit

Select Top 1000000 tblSoftwareUni.softwareName,
  tNotInstalled.AssetID,
  tNotInstalled.AssetName
From tblSoftware
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetID
  Left Join (Select tblSoftwareUni.SoftID,
    tblAssets.AssetID,
    tblAssets.AssetName
  From tblSoftwareUni,
    tblAssets
    Inner Join tblComputersystem
      On tblAssets.AssetID = tblComputersystem.AssetID
  Where tblAssets.Assettype = -1 And tblComputersystem.Domainrole < 2 And
    Not Exists(Select tblSoftware.softID,
      tblSoftware.AssetID From tblSoftware
    Where tblSoftware.softID = tblSoftwareUni.SoftID And tblSoftware.AssetID =
      tblAssets.AssetID)) tNotInstalled On tNotInstalled.SoftID =
    tblSoftware.softID
Where tblAssets.AssetName = 'Reference'
Order By tblSoftwareUni.softwareName,
  tNotInstalled.AssetName