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'
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'