Query translation in Active Record format

[eluser]Alhazred[/eluser]
How to write this query in Active Record format?

Code:

SELECT c.id AS id,c.name AS name,t.name AS category
FROM category c, type t
WHERE t.id = c.category
ORDER BY c.name