V_PLANNEDGIFTREVENUE_WITHADDITIONS

CREATE view dbo.V_PLANNEDGIFTREVENUE_WITHADDITIONS
as

  select
    PLANNEDGIFTREVENUE.ID as PLANNEDGIFTID,
    null as PLANNEDGIFTADDITIONID,
    PLANNEDGIFTREVENUE.REVENUEID,
    0 as ISADDITION
  from
    dbo.PLANNEDGIFTREVENUE

  union all

  select
    PLANNEDGIFTADDITION.PLANNEDGIFTID as PLANNEDGIFTID,
    PLANNEDGIFTADDITIONREVENUE.ID as PLANNEDGIFTADDITIONID,
    PLANNEDGIFTADDITIONREVENUE.REVENUEID,
    1 as ISADDITION
  from
    dbo.PLANNEDGIFTADDITIONREVENUE
  inner join 
    dbo.PLANNEDGIFTADDITION on PLANNEDGIFTADDITION.ID = PLANNEDGIFTADDITIONREVENUE.ID