Custom Warranty Status Report

[bpc]

Hello. I'm customizing the warranty status report with the code listed below. It works, except I'm trying to eliminate duplicate service tag numbers. How can I modify the query to accomplish this?

Thank you.

Select Top 1000000 tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,     web40lastlogontop.lastuser, tblComputerSystemProduct.IdentifyingNumber,     Web40OSName.OSname, tblComputers.Computer, tblComputersystem.Model,     web40allcompstates.Computername, web40allcompstates.Statename From   tblComputers Inner Join   tblCompCustom On tblComputers.Computername =   tblCompCustom.Computername   Inner Join   tblComputerSystemProduct On   tblComputers.Computername =     tblComputerSystemProduct.Computername Inner   Join   web40lastlogontop On web40lastlogontop.Computername =       tblComputerSystemProduct.Computername Inner Join   Web40OSName On          Web40OSName.Computername = web40lastlogontop.Computername   Inner Join     tblComputersystem On tblComputers.Computername =       tblComputersystem.Computername Inner Join   web40allcompstates On   web40allcompstates.Computername =     Web40OSName.Computername            

[Hemoco]

try this one:

Select Top 1000000 tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,
tblComputerSystemProduct.IdentifyingNumber, Web40OSName.OSname,
tblComputers.Computer, tblComputersystem.Model,
web40allcompstates.Computername, web40allcompstates.Statename,
tblComputers.Userdomain, tblComputers.Username
From tblComputers Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername