sqlserver中:
SELECT ',' + SMSChannel
FROM SSC AS TT
WHERE TT .FS_SMS_ID = SSC.FS_SMS_ID
FOR XML PATH('')
mysql中:
SELECT GROUP_CONCAT(SMS_CHANNEL, '')
FROM SSC AS TT
WHERE TT .FS_SMS_ID = SSC.FS_SMS_ID
两者效果相同
sqlserver中:
SELECT ',' + SMSChannel
FROM SSC AS TT
WHERE TT .FS_SMS_ID = SSC.FS_SMS_ID
FOR XML PATH('')
mysql中:
SELECT GROUP_CONCAT(SMS_CHANNEL, '')
FROM SSC AS TT
WHERE TT .FS_SMS_ID = SSC.FS_SMS_ID
两者效果相同