9 lines
116 B
MySQL
9 lines
116 B
MySQL
|
SELECT
|
||
|
|
m.*,
|
||
|
|
dt.Name AS device_type_name
|
||
|
|
FROM
|
||
|
|
Model m
|
||
|
|
JOIN
|
||
|
|
DeviceType dt ON m.DeviceTypeID = dt.ID;
|
||
|
|
|