我用这个代码:
SELECT distinct members.name,
REPLACE(RTRIM((SELECT CAST([cat_name] AS VARCHAR(MAX)) + ' '
FROM category
INNER JOIN specialisation
ON category.cat_id=specialisation.cat_id
WHERE (member_id = members.member_id) FOR XML PATH (''))),' ',', ') AS cat_name
FROM specialisation
INNER JOIN members
ON specialisation.member_id = members.member_id
INNER JOIN city_list
ON members.city = city_list.city_id
INNER JOIN category
ON specialisation.cat_id = category.cat_id
INNER JOIN state_list
ON members.state = state_list.state_id where qualification_id=1
但我得到了这样的结果是:
名称cat_name
--------------------------------------------------
sanjit银行,市场营销
拉吉夫・商业,法律,民事法律,家庭,法律
每一个字是由逗号分开,但我需要像商业法,民法,家庭法
请任何一个可以帮助我
感谢
我这样LT使用传统的ASP和显示数据;%= RS("cat_name)%GT;