SQL - table holds to dates, I want to retrive all dates in a period of time

Home -> Community -> Usenet -> c.d.o.misc -> SQL - table holds to dates, I want to retrive all dates in a period of time

From: Anders F. <afromyr_at_hotmail.com>
Date: 20 Feb 2004 04:56:08 -0800
Message-ID: <b7aaadbb.0402200456.564ff0dd@posting.google.com>

My problem is that i have a table with a from_Date and a to_date. this table holds information about a persons sickdays.

Lets say that the table contains the following info Employee - from_date - to_date

2604 - 14.02.2004 - 03.03.2004
5064 - 16.02.2004 - 17.02.2004
2604 - 01.01.2002 - 01.01.2002
2359 - 01.05.2003 - 01.05.2004

I want to ask who whas sick between 01.01.2004 and 01.03.2004 And get a list of all employees that has sickdays that is in this period

Employee - from_date - to_date

2604 - 14.02.2004 - 03.03.2004
5064 - 16.02.2004 - 17.02.2004
2359 - 01.05.2003 - 01.05.2004

How would I write the where sentence to get this info? select * from tbl where ? Received on Fri Feb 20 2004 - 06:56:08 CST