Sorting with Custom tables.

[WishER]

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;

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