Kentico: QueryRepeater JOINS

query-repeater-joins.sql

SELECT 0 AS TableID -- IFDA_Event Identifier
	  ,EventTitle AS Title
      ,EventSummary AS EventSummary
      ,AlignContent AS AlignContent
      ,EventLocation AS LocationTopic
      ,EventDate AS ItemDate
      ,EventDateEnd AS ItemDateEnd
      ,FeaturedEvent AS Featured
      ,EventBannerImage AS BannerImage
      ,EventFacility AS Facility
      ,DocumentURLPath
      ,NodeAliasPath
  FROM IFDA_Event INNER JOIN View_CMS_Tree_Joined ON EventID = DocumentForeignKeyValue
  WHERE FeaturedEvent = 1 AND ClassName = 'IFDA.Event'
UNION
SELECT 1 AS TableID -- IFDA_News Identifier
	  ,ArticleTitle AS Title
      ,ArticleTeaserText AS EventSummary
      ,AlignContent AS AlignContent
      ,ArticleTopic AS LocationTopic
      ,ArticleDate AS ItemDate
      ,ArticleDate AS ItemDateEnd --dummy field
      ,FeaturedArticle AS Featured
      ,FeaturedArticleImage AS BannerImage
      ,ArticleDetails AS Facility --dummy field
      ,DocumentURLPath
      ,NodeAliasPath
  FROM IFDA_News INNER JOIN View_CMS_Tree_Joined ON NewsID = DocumentForeignKeyValue
  WHERE FeaturedArticle = 1 AND ClassName = 'IFDA.News'