spGetEmailListsFromAppeal

CREATE  Procedure [dbo].[spGetEmailListsFromAppeal]
@EmailProjectAppealID int

as

  SELECT el.[ID] "EmailListID"
      ,el.[ClientsID]
      ,el.[OwnerID]
      ,el.[Deleted]
      ,el.[Name]
      ,el.[Description]
      ,el.[Guid]
      ,el.[Subscription]
      ,el.[type]
      ,el.[DataSourceID]
      ,el.[Options]
      ,epal.[AppealListType]
      ,epal.[EmailProjectAppealID]
      ,epal.[ID] "AppealListID"
  FROM [dbo].[EmailList] el inner join EmailProjectAppeal_EmailList epal on el.[ID] = epal.[EmailListID]
  WHERE epal.[EmailProjectAppealID] = @EmailProjectAppealID
    AND epal.Deleted = 0