sql语句查询的结果进行拼接显示 SELECT pt.pt_id, concat(pt_name,'-',h_bz.h_bz_zr,'元') pt_name, #把查询的多个结果拼接显示 pt_zcname, po_id FROM h_post_title pt INNER JOIN h_bz ON pt.pt_id = h_bz.pt_id where h_bz.h_bz_is='是'