Mysql query help [RESOLVED]

[Kenix]

Well it's not about lua but anyway

I have query

SELECT  
    `finish_time`, `data_maps_finish_time`.`account_id` AS `account_id`, `checkpoints_time`  
FROM  
    data_maps_finish_time  
LEFT JOIN  
    data_maps_checkpoints_time  
ON  
    data_maps_finish_time.account_id = data_maps_checkpoints_time.account_id  
ORDER BY  
    `finish_time`  
LIMIT 2 

I want get `nick` from another `users` table by `account_id` returned.

Example `users` table

id | nick

1 Kenix

Edited September 30, 2012 by Guest

[Kenix]

SELECT  
    `finish`.`finish_time`, `finish`.`account_id` AS `account_id`, `checkpoints`.`checkpoints_time`, `users`.`nick`  
FROM  
     data_maps_finish_time AS finish  
LEFT JOIN  
     data_maps_checkpoints_time AS checkpoints  
ON  
     finish.account_id = checkpoints.account_id  
JOIN  
   `users` 
ON  
    users.account_id = checkpoints.account_id  
ORDER BY  
   `finish_time`  
LIMIT 2 

Resolved.