SELECT
    m.*,
    dt.Name AS device_type_name
FROM
    Model m
JOIN
    DeviceType dt ON m.DeviceTypeID = dt.ID;