in reply to Re^4: Problems Using Join in DBIx::Class
in thread Problems Using Join in DBIx::Class

The condition you want is

sent_mail is NOT ( null OR '0000-00-00' )

which by De Morgan's Laws is

sent_mail is ( NOT null AND NOT '0000-00-00' )

The rule is 'the complement of the union of two sets is the same as the intersection of their complements'

poj
  • Comment on Re^5: Problems Using Join in DBIx::Class