Got id, not name

[Thierry]

I got a table with a list of names (and their ids) and another table which has a field that contains some of those IDs.
When I want to ORDER BY the IDs in table 2, it (naturally) orders by number. (1,2,3...).
What I want, is it to order by the names from table 1 instead althought only the IDs are in table 2.
It was something in a query with AS but I cant seem to find it again.
Any ideas?

[Thierry]

Never mind, seem to have found it again, forgot about the whole table_1.id = table_2.id :p