Select Top 1000000 'globe-green.png' As Icon,
  tblExchangeMailbox.DisplayName,
  tblExchangeMailbox.Alias,
  tblExchangeMailbox.RecipientType,
  tblExchangeMailbox.RecipientTypeDetails,
  addresses.email As EmailAddress,
  tblExchangeServer.AssetId As ServerAssetId,
  tblExchangeServer.Name As ExchangeServer
From tblExchangeMailbox
  Left Outer Join (Select Min(tblExchangeMailboxAddress.Address) As email,
        tblExchangeMailboxAddress.MailboxId
      From tblExchangeMailboxAddress
      Group By tblExchangeMailboxAddress.MailboxId) addresses On
    addresses.MailboxId = tblExchangeMailbox.MailboxId
  Inner Join tblExchangeServer On tblExchangeServer.ServerId =
    tblExchangeMailbox.ServerId
Order By tblExchangeMailbox.DisplayName