Comparing 2 dates

You mean like this?
-- Select customers who joined and ended anywhere between
-- 2007-05-01 and 2007-12-01 (inclusive.)
SELECT CustID
FROM tbl_CustMaster
WHERE JoinDate >= '2007-05-01' AND EndDate < '2007-12-02';

I have a table like this

CREATE TABLE tbl_CustMaster
(
CustID BIGINT IDENTITY(1,1)
CustName VARCHAR(100),
JoinDate DateTime,
EndDate DateTime
)

Now I want to run a query in which I want to extract custID which lies between JoinDate and EndDate. Can someone help me in doing this??

SELECT CustID
FROM tbl_CustMaster
WHERE JoinDate >= '2007-05-01' AND EndDate < '2007-12-02';