Could I get asset tags added to this report?

[ESIT]

Hello, the following has everything I need except I need Asset Tags included and I can't figure out how to add that without messing everything else up. Here's the code if someone could help add Asset Tags to this:

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname, Web40OSName.SP, tblOperatingsystem.Description, dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon, dbo.tblComputers.LastknownIP, dbo.tblComputersystem.Model, dbo.tblComputersystem.Manufacturer From dbo.tblComputersystem Inner Join dbo.tblComputers On dbo.tblComputersystem.Computername = dbo.tblComputers.Computername Inner Join dbo.web40ActiveComputers On dbo.tblComputers.Computername = dbo.web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername Inner Join tblOperatingsystem On dbo.tblComputers.Computername = tblOperatingsystem.Computername Where dbo.tblComputersystem.Domainrole < '2' Order By dbo.tblComputers.Computer


Thanks!

[ESIT]

Forgot to mention, this worked like a charm, thanks!

[Hemoco]

Select Top 1000000 dbo.tblComputers.Computername,
  dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
  Web40OSName.SP, tblOperatingsystem.Description,
  dbo.tblComputersystem.Lastchanged, Web40OSName.Compimage As icon,
  dbo.tblComputers.LastknownIP, dbo.tblComputersystem.Model,
  dbo.tblComputersystem.Manufacturer, tblComputerSystemProduct.IdentifyingNumber
From dbo.tblComputersystem Inner Join             
  dbo.tblComputers On dbo.tblComputersystem.Computername =
    dbo.tblComputers.Computername Inner Join
  dbo.web40ActiveComputers On dbo.tblComputers.Computername =
    dbo.web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
  Inner Join
  tblOperatingsystem On dbo.tblComputers.Computername =
    tblOperatingsystem.Computername Inner Join
  tblComputerSystemProduct On dbo.tblComputers.Computername =
    tblComputerSystemProduct.Computername
Where dbo.tblComputersystem.Domainrole < '2'
Order By dbo.tblComputers.Computer