Does anyone know how to configure the join component to do the following;
from events a
left join date_range b
on a.event_date between b.start_date and b.end_date
Where table ‘a’ contains a list of event dates, and table ‘b’ contains a series of date ranges. I want to return the date range per event date.