[thelist] SQL Help needed

[Andrew Forsberg]

>   What I have at the moment is
>
>SELECT * FROM TableA
>order by paiduntil, lastloggedon
>
>   Obviously the above statement is wrong.  Any help would be appreciated.

If I understand you correctly, I think you want:

SELECT this, that, and, the_other
FROM TableA
ORDER BY paiduntil DESC, lastloggedon DESC

I'm fairly sure the NULL paiduntil values should come last as a
result of the first ORDER criteria. Could be wrong though.

Cheers
Andrew

--
Andrew Forsberg
---
uberNET - http://uber.net.nz/
the pander - http://thepander.co.nz/