select distinct b.BROKER_NAME, b.BROKER_ID from tblBrokers b with (nolock) inner join tbl_SSO_Providers ssoProv with (nolock) on ssoProv.DomainOwnerID = b.BROKER_ID and ssoProv.DomainOwnerType = 'BRO' order by b.BROKER_NAME for json auto, include_null_values