Computers with more than one hard disk

[danielk]

Hi There, how do I generate a report on Computers with more than one hard disk.
Thanks

[Niko0 · Accepted solution]

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  tblAssets.Username,
  tblFloppy.Model,
  tblAssets.Lastseen,
  SubQuery1.HDDcount
From tblAssets
  Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
  Inner Join (Select Top 1000000 tblFloppy.AssetID,
    Count(tblFloppy.floppyID) As HDDcount
  From tblFloppy
  Group By tblFloppy.AssetID) SubQuery1 On SubQuery1.AssetID = tblAssets.AssetID
Where SubQuery1.HDDcount > 1
Order By tblFloppy.Name