SQL Problem with selecting dates

[AllMememe]

I have a table called Match which has columns DateFrom and DateTo. I need my query to get all records that have their DateFrom OR DateTo between two selected dates.

I tried:

Select distinct P.FName, M.Team from Match M Person P where P.Team = M.Team and M.DateFrom OR M.DateTo between #02/Feb/2011# and #09/Feb/2011#

This however returns all the wrong records.

Any help would be appreciated. Thanks.

 

[SkipVought]

You missed a COMMA in the FROM andBETWEEn for BOTH dates...

Select distinct
  P.FName
, M.Team 
from
  Match M
, Person P 
where P.Team = M.Team
  and (M.DateFrom between #02/Feb/2011# and #09/Feb/2011#
   OR  M.DateTo between #02/Feb/2011# and #09/Feb/2011#)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AllMememe]

Worked great! Thank you!

 

[SkipVought]

please note that the PARENTHESES are very important to the logic that you stated.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}