Syntax Error, Calling All SQL Gurus!

I'm having trouble with the select below. The problem is in the WHERE clause.
The Query Builder says this: "Query Definitions Differ. Error in WHERE clause near '('. Unable to parse query text."
Here is my code: SELECT Members.MemberID,
MemberFamily.FamilyID,
MemberFamily.FamFirstName,
MemberFamily.FamLastName,
MemberFamily.Relation,
Members.Street,
CASE
WHEN MemberFamily.Phone IS NULL THEN (SELECT TOP 1 Phone.Phone
FROM Phone
WHERE Phone.MemberID = MemberFamily.MemberID)
ELSE MemberFamily.Phone
END AS Phone,
CASE
WHEN MemberFamily.Email IS NULL THEN (SELECT TOP 1 Email.Email
FROM Email
WHERE Email.MemberID = MemberFamily.MemberID)
ELSE MemberFamily.Email
END AS Email,
Checkin.Date
FROM MemberFamily
INNER JOIN Members
ON MemberFamily.MemberID = Members.MemberID
INNER JOIN Checkin
ON MemberFamily.FamilyID = Checkin.FamilyID
WHERE (SELECT *
FROM Checkin
WHERE (Checkin.FamilyID = 11)
AND (Checkin.Date BETWEEN '02/01/2008' AND '03/01/2008'))
AND (NOT (SELECT *
FROM Checkin
WHERE (Checkin.FamilyID = 11)
AND (Checkin.Date BETWEEN '04/16/2008' AND '04/19/2008')))  
 I can run it without the WHERE clause and it works fine and I can run these arguments separately and they run without errors also: 
SELECT *
FROM Checkin
WHERE (Checkin.FamilyID = 11)
AND (Checkin.Date BETWEEN '02/01/2008' AND '03/01/2008') SELECT *
FROM Checkin
WHERE (Checkin.FamilyID = 11)
AND (Checkin.Date BETWEEN '04/16/2008' AND '04/19/2008')