This image shows the join diagram with the PROMOTIONS table renamed to CAMPAIGNS.