sql xml
SELECT ','''+MA001+''''
FROM BOMMA INNER JOIN
BOMMB ON BOMMA.MA001 = BOMMB.MB001 AND BOMMA.MA002 = BOMMB.MB002 AND
BOMMA.MA003 = BOMMB.MB003
FOR XML PATH('')
----------------------------结果
,'13N0-WDU0X01 ','13N0-WDU0X01 ','13N0-WDU0X01 ','13N0-WDU0X01 ','21MA0011W-A00 ','21MA0011W-A00 ','332-07100K01-W ','332-09030F01-W ','332-10058A01-W ','332-11016A01-W ','334-08055B01-W ','334-08055B01-W ','334-08079B01-T ','334-08079B01-T ','334-08079B01-T ','334-08079B01-T ','334-08079B01-T ','334-08079B01-T ','334-08089A01-T ','334-08089A01-T ','334-08089A01-T ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-08089B01-W ','334-09038A01-T ','334-09038A01-T ','334-09038A01-T ','334-09038A01-T ','334-10019A01-T ','334-10019A01-T ','334-10019B01-T ','334-10019B01-T ','335-08114A01-W ','335-08114A01-W ','335-08114A01-W ','335-08129B01-W ','335-08129B01-W ','335-08129B01-W ','335-09023A01-T ','335-09073A01-W ','335-09073A01-W ','335-09073A01-
---------------------------
select stuff((SELECT ','''+MA001+''''
FROM BOMMA INNER JOIN
BOMMB ON BOMMA.MA001 = BOMMB.MB001 AND BOMMA.MA002 = BOMMB.MB002 AND
BOMMA.MA003 = BOMMB.MB003
FOR XML PATH('')),1,1,'')
----------------------------------------结果
'13N0-WDU0X01 ','13N0-WDU0X01 ','13N0-WDU0X01 ','13N0-WDU0X01 ','21MA0011W-A00 ','21MA0011W-A00 ','332-07100K01-W ','332-09030F01-W '
