SELECT `u` . `FirstName` , `u` . `FSPNumber` , `u` . `LastName` , `u` . `Id` , `u` . `RoleStr` , `a` . `IsActive` , `a` . `IsDeleted` , `u` . `CreatedBy` FROM `User_Master` AS `u` INNER JOIN `AspNetUsers` AS `a` ON `u` . `Email` = `a` . `Email` WHERE ( `a` . `IsDeleted` = FALSE ) AND `a` . `IsActive` 