select e.*, t1.code_name, t2.code_name
from vio_evidence e, t_code t1, t_code t2
where e.evidence_type = trim(t1.code_no)
and t1.code_type = '204'
and e.plate_type = trim(t2.code_no)
and t2.code_type = '20'
转载于:https://www.cnblogs.com/hl3292/archive/2010/11/11/1875027.html