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]