Combining 2 tables

[mrknowledge]

Table A has a number that ID's an entry in Table B.  Table B then has a list of names with the id.  Is there a way to 'alphabatize' Table A with Table B's names?

[artacus]

SELECT a.*
FROM a
JOIN b ON a.id = b.a_id
ORDER BY b.name