select b.NR1 as hpzl,a.hphm,a.wfdd,a.wfrq,a.fkpjhm,a.fkje,c.NR1 as wzlx,c.NR1 as cldd,a.clrq,a.clry from
punishment a ,punish_code b ,puinsh_code c ,puinsh_code d --,operator e
where a.hpzl=b.dm and b.lb='号牌种类'
and a.wzlx=c.dm and c.lb='违法类型'
and a.cldd=d.dm and d.lb='部门'