本文共 964 字，大约阅读时间需要 3 分钟。

���������������

id,create_by,create_time,update_by,update_time,delete_flag,import_flag,company_id,etab_code,etab_desc,etab_type,etab_unitid,etab_deptid        ,etab_postid,etab_pernum,etab_isctrl,status,etab_sdate,etab_edate,comment,etab_takeupsum  
  
  
SELECT  
FROM org_eatabinfo as o1,org_post as o2  
where  
o1.delete_flag=0 and o2.delete_flag=0 and o1.etab_postid=o2.id and o2.post_cname like concat('%',#{postName}, '%');

���������������

id,create_by,create_time,update_by,update_time,delete_flag,import_flag,company_id,etab_code,etab_desc,etab_type,etab_unitid,etab_deptid        ,etab_postid,etab_pernum,etab_isctrl,status,etab_sdate,etab_edate,comment,etab_takeupsum  
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
   
  
  
   
  
SELECT  
FROM org_eatabinfo as o1,org_post as o2  
where  
o1.delete_flag=0 and o2.delete_flag=0 and o1.etab_postid=o2.id and o2.post_cname like concat('%',#{postName}, '%');