[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