MAC Addresses

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblNetwork.Description As [Network Card],
  tblNetwork.MACaddress,
  tsysOS.Image As icon,
  tblNetwork.IPAddress,
  tblNetwork.Lastchanged
From tblAssets
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblNetwork.IPEnabled = 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName