USP_DATALIST_PEOCLIENTUSERS

CREATE procedure dbo.USP_DATALIST_PEOCLIENTUSERS
as
    set nocount on;

    select cu.UserName,
           cu.EMail,
           cu.ID CLIENTUSERSID,
       cue.IDENTIFIER PEID,
       cue.ID CLIENTUSERSEXTENSIONID

    from dbo.ClientUsers cu
  inner join dbo.ClientUsersExtension cue on cue.ClientUserID = cu.ID
    where cue.ProviderName='PatronEdgeOnline'