USP_APPUSER_GETBYEMAILADDRESS

CREATE procedure dbo.USP_APPUSER_GETBYEMAILADDRESS(@EMAILADDRESS nvarchar(100))
as
begin
    select 
        APPUSER.ID,
        APPUSER.USERSID,
        APPUSERCLAIMS.NAMEIDENTIFIER
    from dbo.APPUSER
    left outer join dbo.APPUSERCLAIMS
        on APPUSER.ID = APPUSERCLAIMS.APPUSERID
    where APPUSER.EMAILADDRESS = @EMAILADDRESS;
end;