【六袆 - IDEA】DG，将多行SQL合并成一行SQL；

快捷键

转换前

select a.user_id                                                                userid,
       a.user_no                                                                userno,
       a.user_name                                                              username,
       d.emp_sex                                                                empsex,
       (SELECT t.dept_name FROM dept_relation t WHERE t.dept_no = a.dept_no) deptname,
       a.emp_no                                                                 empno,
       d.telephone                                                              telephone,
       b.role_no,
       d.mobile_phone                                                           mobilephone,
       d.mail_address                                                           mailaddress,
       d.id_factory                                                             idfactory,
       NULL                                                                     factory,
       d.cost_no                                                                costno,
       d.info_longevity                                                         infolongevity,
       d.id_mgr                                                                 idmgr,
       d.dat_in                                                                 datein,
       d.ssbu                                                                   ssbu,
       a.site_no                                                                siteno,
       a.is_internal_user                                                       isinternaluser,
       a.language                                                               LANGUAGE,
       a.is_enable                                                              isenable,
       a.creater                                                                creater,
       a.create_date                                                            createdate,
       a.owner_dept                                                             ownerdept,
       a.modify_user                                                            modifyuser,
       a.modify_date                                                            modifydate,
       a.invalid_date                                                           invaliddate,
       a.affix_level                                                            affixlevel
from  user a
         left join user_role b on a.user_no = b.user_no
         left join role c on b.role_no = c.role_no
         left join  employee d on a.emp_no = d.emp_no
where b.role_no = ?
order by a.user_no

转换后

select a.user_id   userid,a.user_no  userno,a.user_name   username,d.emp_sex  empsex,(SELECT t.dept_name FROM pd_dept_relation t WHERE t.dept_no = a.dept_no) deptname,a.emp_no   empno,d.telephone     telephone,b.role_no,d.mobile_phone     mobilephone,d.mail_address   mailaddress,d.id_factory   idfactory,NULL   factory,d.cost_no    costno,d.info_longevity   infolongevity,d.id_mgr   idmgr,d.dat_in    datein,d.ssbu    ssbu,a.site_no       siteno,a.is_internal_user       isinternaluser,a.language     LANGUAGE,a.is_enable         isenable,a.creater            creater,a.create_date          createdate,a.owner_dept            ownerdept,a.modify_user     modifyuser,a.modify_date      modifydate,a.invalid_date    invaliddate,a.affix_level    affixlevel from  user a left join  user_role b on a.user_no = b.user_no left join  role c on b.role_no = c.role_no left join  employee d on a.emp_no = d.emp_no where b.role_no = ?  order by a.user_no