SQL 把一张表虚拟成两张表

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'