Multiple records in my custom report

[oiverson]

i was playing building a report and i was going along fine until i added some fields that created 18 records for each machine. i tried to back out of those fields, but they seemed to have stuck. i'm a complete idiot with SQL, so i was wondering if anyone saw anything glaring in my statement below.

i have no problem recreating the statement being careful to not hit those fields that i added (i think they were the ones just below the tbl. fields)


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblOperatingsystem.Organization,
tblBIOS.Manufacturer,
tblAssets.Description,
tblAssets.Processor,
tblProcessor.NumberOfCores,
tblAssets.Memory,
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblBIOS.SerialNumber,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblDesktop On tblAssets.AssetID = tblDesktop.AssetID

[oiverson]

thanks!

[poweld1]

Put Distinct in the first line, i.e. Select Distinct Top 1000000 tblAssets.AssetID,