Someone

SELECT * FROM component cINNER JOIN componenttype ct ON ct.id = c.componenttype_idORDER BY c.serial, ct.name