Select Top 1000000 'user.png' As Icon, tblO365User.DisplayName, tblO365User.UserPrincipalName, tblADusers.Username, tblADusers.Userdomain, tblO365User.AccountEnabled As Enabled, tblO365User.Department, tblO365User.Mail, tblO365User.ResetPasswordOnNextLogon, tblO365Organization.DisplayName As Organization, tblO365Organization.TenantId From tblO365User Inner Join tblO365Organization On tblO365User.OrganizationId = tblO365Organization.OrganizationId Left Outer Join tblADusers On tblADusers.UPN = tblO365User.UserPrincipalName Order By tblO365User.DisplayName