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='是'
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='是'