- 使用group_concat合并多行查询结果为一行
select gs.id id,gs.gs_no gs_no,gs.apply_date apply_date,gs.create_by create_by,group_concat(gd.name) name,gs.apply_description apply_description,gd.unit_name unit_name,gs.apply_status apply_status,gs.apply_by apply_by from goods_scrap gs left join goods_scrap_items gsi on gs.gs_no = gsi.gs_no left join goods gd on gd.gds_id = gsi.gds_id WHERE gs.id=64 GROUP BY gs.id
- 使用concat合并多列查询结果为一列
select gd.sgc_name gtype,concat(gd.spec,gd.`name`) gname from goods gd WHERE gd.unit_name = ( select sd.dict_value from sys_dict_data sd where sd.dict_type="goods_unit" and sd.dict_label="信息科" )
sql查询结果合并
最新推荐文章于 2024-03-06 15:11:42 发布