Goal: Join multiple attributes using PKs and then add multiple rows with unique Ids; d.activity_date, d.activity_type_id using ON d.lead_id AND d.activity_date between a.effective_start_date, a.effective_end_date. This will give me a table I can use to pivot and view activity by a specific a.journey_id. Current Outcome: When I add in the my second AND clause of less than a.effective_end_date […]
Read More