如何编写带有2个日期范围的sql子查询(how to write sql subquery with 2 date ranges)

 我是SQL的新手，我对以下SSRS报告所需的查询有困难。 
 
 我们有一个表列出了名称和日期。 日期对应于该人参加活动的日期。 我们想要运行带有日期范围的查询，并提取已参加该日期范围内事件的名称列表及其所有出勤日期，即使其中一个日期超出范围 
 
 对于桌子 
 
NAME, DATE OF ATTENDENCE
ALICE, 1/1/2000
BOB, 1/1/2000
CHARLIE, 1/1.2000
ALICE, 1/1/2001
ALICE, 1/1/2002
BOB, 1/1/2002
 
 我们想要查询一年，比如2002年，然后查看参加02年活动的所有人的名单，以及这些人的所有其他出勤日期，所以2002年会显示 
 
ALICE, 1/1/2000
ALICE, 1/1/2001
ALICE, 1/1/2002
BOB, 1/1/2000
BOB, 1/1/2002
 
 我在如何解决这个问题上遇到了麻烦，我认为我需要多个查询，但我不能完全理解如何做到这一点。 
 
 任何帮助或建议将不胜感激。 
 
 谢谢。 
 
 MC 

I am new to SQL and am having difficulty with the queries needed for the following SSRS report. 
 
We have one table that's lists name, and date. The date corresponds with the date that person has attended an event. We'd like to run a query with a date range, and pull up a list of names that have attended an event in that date range along with ALL of their attendance dates, even if one of the dates is outside the range
 
so for table
 
NAME, DATE OF ATTENDENCE
ALICE, 1/1/2000
BOB, 1/1/2000
CHARLIE, 1/1.2000
ALICE, 1/1/2001
ALICE, 1/1/2002
BOB, 1/1/2002
 
We would want a to query for a year, say 2002, and then see a list of anyone who had attended an event in 02, and all the other attendance dates for those people, so 2002 would show
 
ALICE, 1/1/2000
ALICE, 1/1/2001
ALICE, 1/1/2002
BOB, 1/1/2000
BOB, 1/1/2002
 
I'm having trouble with how to approach this , I assume I need multiple queries, but cant quite wrap my head around how to do this. 
 
Any help or advice would be appreciated. 
 
Thanks. 
 
MC

原文：https://stackoverflow.com/questions/21346619