MySQL OUTER JOIN problem


2008-02-28 06:06:01 AM
delphi58
Does MySQL have some weird quirk regarding OUTER JOINs? I have this
query:
SELECT Date,P.Category,P.Person
FROM Bookings B RIGHT OUTER JOIN People P ON(B.Person=P.Person)
WHERE P.Category = '2' AND ((EndDate>='2008-02-01' And
Date<'2008-02-28') OR DATE IS NULL)
This works fine on DBISAM but on MySQL it is not including
non-matching records from the People table. Can someone explain why?
I thought it might be the Date field so I modified the SQL to just use
the EndDate field but still get a similar effect.
Thanks in advance.