Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblOperatingsystem.Caption,
  tblOperatingsystem.Version
From tblAssets
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblOperatingsystem.Caption Like '%Windows 10%'