Problem with left join on not null datetime

I'm having a problem with Distrib 3.23.42 with the following query: select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null; I'm finding that a left join on datetime fields that do not allow nulls is not working when I'm trying to emulate a subselect to find non-matching values

Re: Problem with left join on not null datetime

At 12:57 PM -0700 11/15/01, Mark A Ohrenschall wrote: I'm having a problem with Distrib 3.23.42 with the following query: select x1.*,x2.* from x1 left join x2 on x1.d1=x2.d2 where x2.d2 is null; I'm finding that a left join on datetime fields that do not allow nulls is not working when I'm