sql 语句优化，将2行查询结果合并到一行。

Question

select emp_chg_other.s_name,project_table.project_name from kc_billhead,project_table,emp_chg_other,hr_epm_station,fg_ogm_station where kc_billhead.tr_proj=project_table. pc and project_table.pc=emp_chg_other.chg_data and emp_chg_other.emp_id=hr_epm_station.ccode and hr_epm_station.station=fg_ogm_station.cno and hr_epm_station.station='0106' and kc_billhead.billno='CGRK20180102001';

Answer 1

有一种死办法，concat(字段1，字段2)
具体写法 select concat（(select 字段A from 表 where 条件=第一行),(select 字段A from 表 where 条件=第二行)）；这样即可