一张表里的多个字段值 取自 字典表里的text 的查询

为什么80%的码农都做不了架构师？>>>   

 

SELECT z.`train_num`,z.`train_basemode`, z.`train_brake`, z.train_drag,z.`train_shock`,
         b.`dict_text` AS basemode,a.`dict_text` AS brake ,c.`dict_text` AS traintype,d.dict_text AS machinetype,
         e.dict_text AS traindrag,  f.dict_text AS trainshock
 
FROM t_b_train  z
INNER JOIN t_sys_dictionary a ON   z.`train_brake`  = a.`id`
INNER JOIN t_sys_dictionary b  ON  z.`train_basemode`=b.`id`
INNER JOIN t_sys_dictionary c  ON  z.`train_type`=c.`id`
INNER JOIN t_sys_dictionary d  ON z.machine_type = d.`id`
INNER JOIN t_sys_dictionary e  ON z.train_drag = e.`id`
INNER JOIN t_sys_dictionary f  ON z.train_shock = f.`id`

 

转载于:https://my.oschina.net/mellen/blog/1582317