[sqlite] trying to exclude records which have a field that is null

[e-mail mgbg25171]

    wSQL = _
    "Select f.* " & _
    "from firms f " & _
    "left join " & _
    "(" & _
        "select firm_id, max(by_or_on) as boo " & _
        "from calls " & _
        "group by firm_id " & _
"having by_or_on is not null " & _    <==========THIS ISN'T DOING IT FOR ME
AND I'D LIKE TO KNOW WHY
        "order by by_or_on desc" & _
    ") c " & _
    "on c.firm_id = f.id " & _
    "order by boo desc;"

Any help much appreciated
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users