类似如下,改一下啦 SELECT psId,psTyp,psRe CASE tpId WHEN '01' THEN '新成长青年' END AS input, CASE tpId WHEN '02' THEN outquty END AS out, CASE tpId WHEN '003' THEN outquty END AS retn FROM tbperson a,tblTyp b where a.tpId =b.tpId
SELECT psId,psTyp,psRe CASE tpId WHEN '01' THEN '新成长青年' WHEN '02,05' THEN '失业再就业人员,失业人员' WHEN '01,02,05' THEN '新成长青年,失业再就业人员,失业人员 ' //这边还有多少个组合就写多少个,类似上面就可以拉 END AS test, FROM tbperson a,tblTyp b where a.tpId =b.tpId
可以这样:将tblTyp中的记录读到数组中,然后在显示时循环替换一下
SELECT psId,psTyp,psRe
CASE tpId WHEN '01' THEN '新成长青年' END AS input,
CASE tpId WHEN '02' THEN outquty END AS out,
CASE tpId WHEN '003' THEN outquty END AS retn
FROM tbperson a,tblTyp b
where a.tpId =b.tpId
CASE tpId WHEN '01' THEN '新成长青年'
WHEN '02,05' THEN '失业再就业人员,失业人员'
WHEN '01,02,05' THEN '新成长青年,失业再就业人员,失业人员 '
//这边还有多少个组合就写多少个,类似上面就可以拉
END AS test,
FROM tbperson a,tblTyp b
where a.tpId =b.tpId