SQL-两个表合并数据(字符串合并）

  =====》

CREATE TABLE #t_AQQ(ID INT,MCLASS VARCHAR(20),MYCON VARCHAR(20))INSERT INTO #t_AQQSELECT '1','L-1','测试撒阿斯顿'UNION ALLSELECT '2','L-1','背后是否是否'UNION ALLSELECT '3','L-2','看看是的废卡萨斯'UNION ALLSELECT '4','L-3','SADASD删除是否'UNION ALLSELECT '5','L-1','控件库v刹小'CREATE TABLE #t_SQQ(MCLASS VARCHAR(20),SNO VARCHAR(20))INSERT INTO #t_SQQSELECT 'L-1','223'UNION ALLSELECT  'L-2','34'UNION ALLSELECT 'L-3','876' SELECT t1.MCLASS,   #t_SQQ.SNO, mycon=STUFF((SELECT ','+[mycon] FROM #t_AQQ t WHERE t.MCLASS=t1.MCLASS FOR XML PATH('')), 1, 1, '')FROM #t_AQQ t1JOIN #t_SQQ ON t1.MCLASS = #t_SQQ.MCLASSGROUP BY t1.MCLASS,#t_SQQ.SNOdrop table #t_AQQdrop table #t_SQQ