Report question

Question: SQL join against date ranges?