WishER
08-26-2002, 02:46 PM
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;
------------------------
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;
------------------------