CREATE PROCEDURE [dbo].[GetIntIdByEmail]
	@email  nvarchar(50)

AS
	SELECT
AspNetUsers.UserName
FROM [Common].[tbl_Interpreter_Account].[AspNetUsers] INNER JOIN  [Common].[tbl_Interpreter_Account].[AddIntrepeter]
ON Interpreter_Account.AspNetUserId = AspNetUsers.Id

WHERE
Interpreter_Acount.contact_email = @email