Need help combining these two queries

[darthjones]

I have a table called names with the following fields - id, last_name, first_name. I want to get the last 10 entries based on id and then arrange the results based on last_name. I can do both separately but I can't figure out how to do them at the same time. Can both be done in one query?

Basically, I want to combine the following -

[code]select id from names order by id desc limit 10;
select last_name, first_name from names order by last_name;[/code]

[fenway]

Assuming that you have MySQL 4.1+, you can do this easily in a subquery:

[code]SELECT last_name, first_name FROM names WHERE id IN ( select id from names order by id desc limit 10 ) [/code]

[wickning1]

[code]SELECT last_name, first_name FROM names WHERE id IN ( select id from names order by id desc limit 10 ) ORDER BY last_name[/code]

[fenway]

Oops... I forgot to add back the ORDER BY clause, which would be the whole point! My bad.