SELECT brand.zh_rCN
FROM devicetype_brand db
LEFT JOIN devicetype ON devicetype.id = db.DeviceType_ID
LEFT JOIN brand ON brand.id = db.Brand_ID
WHERE devicetype.id = '7'
http://www.cnblogs.com/cy163/archive/2008/10/16/1312920.html
http://www.oschina.net/question/89964_65912
http://www.w3school.com.cn/sql/sql_join_left.asp