spGetAppealEmails

CREATE  PROCEDURE [dbo].[spGetAppealEmails]
@EmailProjectAppealID int

as

SELECT epale.[ID]
      ,[EmailProjectAppealID]
      ,[EmailProjectAppealListID]
      ,[SampleSize]
      ,[SampleType]
      ,e.[ID] as EmailID
      ,e.[Name]
      ,e.[Type]
  FROM [dbo].[EmailProjectAppeal_ListEmail] epale inner join [dbo].[Email] e
  on epale.[ID] = e.[ProjectAppealListEmailID]
WHERE [EmailProjectAppealID] = @EmailProjectAppealID
      AND epale.Deleted = 0