Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain,
  Web40OSName.Compimage As icon, dbo.tblNetwork.IPAddress,
  dbo.tblNetwork.IPSubnet, dbo.tblNetwork.Lastchanged,
  tbldomainroles.Domainrole, tbldomainroles.Domainrolename
From dbo.tblComputers Inner Join
  dbo.tblNetwork On dbo.tblComputers.Computername = dbo.tblNetwork.Computername
  Inner Join
  dbo.web40ActiveComputers On dbo.tblComputers.Computername =
    dbo.web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
  Inner Join
  tblComputersystem On dbo.tblComputers.Computername =
    tblComputersystem.Computername Inner Join
  tbldomainroles On tbldomainroles.Domainrole = tblComputersystem.Domainrole
Where dbo.tblNetwork.IPAddress <> '0.0.0.0' And dbo.tblNetwork.IPEnabled = 1 And
  dbo.tblNetwork.DHCPenabled = 0 And dbo.tblNetwork.IPAddress <> '' And
  tbldomainroles.Domainrole < 3
Order By dbo.tblComputers.Computer