[thelist] SQL Help needed

Kevin Greene sinnot at iol.ie
Thu Jan 31 19:22:01 CST 2002


Hi,

   Thanks for the quick reply.  But thats not exactly the result I want.

   This sorts the results by "paiduntil" and then "lastloggedon".  While this
is fine for the results that have "paiduntil" as NULL, it orders "paiduntil"
which are not NULL by "paiduntil" and then "lastloggedon", where as I want to
order the results by "lastloggedon" but have the records which have a datestamp
in the field "paiduntil" displayed first.

Regards,
Kevin




More information about the thelist mailing list