LISTING 4: Query Template for Creating Continuous Subscription Table

SELECT a.subscriber_name, a.magazine_name, a.subscription_start,
MIN(b.subscription_end) AS subscription_end
FROM {Start Date Results} a JOIN {End Date Results} b ON
  b.subscriber_name = a.subscriber_name
  AND b.magazine_name = a.magazine_name
  AND b.subscription_end >= a.subscription_start
GROUP BY a.subscriber_name, a.magazine_name, a.subscription_start