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

select gd.sgc_name gtype,concat(gd.spec,gd.`name`) gname 
from goods gd
WHERE gd.unit_name = (select sd.dict_valuefrom sys_dict_data sdwhere sd.dict_type="goods_unit" and sd.dict_label="信息科"
)