Sorting with Custom tables.
 

Hi folks,

I have the following SQL query I wrote. How do i get it to sort based on `u`.joindate? I looked in the table columns and it doesn't seem to be a conventional date. i just wanna through in an order by joindate. THanks in advance!

------------------------

SELECT ntd.*, u.* FROM `norcal_top_dawg` ntd, `user` u WHERE ntd.userid=u.userid ORDER BY ntd.et, ntd.mph, ntd.sixty_foot ASC;

------------------------

WishEr 'ORDER BY joindate' should work ;) because the numbers are only changed to be more 'date - like' looking when calling the vbdate() function ;) regards...

g-force2k2