Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  Case tblPhysicalMemoryHist.Action
    When 1 Then 'Added'
    When 2 Then 'Removed'
  End As Action,
  tblPhysicalMemoryHist.DeviceLocator,
  Ceiling(tblPhysicalMemoryHist.Capacity / 1024 / 1024) As MB,
  TsysMemorytypes.MemoryName,
  tblPhysicalMemoryHist.Lastchanged
From tblAssets
  Inner Join tblPhysicalMemoryHist On
    tblAssets.AssetID = tblPhysicalMemoryHist.AssetID
  Inner Join TsysMemorytypes On tblPhysicalMemoryHist.MemoryType =
    TsysMemorytypes.Memorytype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Order By tblPhysicalMemoryHist.Lastchanged Desc,
  tblAssets.AssetID,
  tblPhysicalMemoryHist.DeviceLocator