如何在MS Access中以逗号分隔获取值 [英] how can i get values with comma separated in MS Access

问题描述

大家好，请帮忙，我怎么能用这样的逗号分隔值

hi any ,please help ,how can i get values with comma separated like this

Create Table tbl_Customer_Bank_Details
(
[Customer ID] int,
[Customer Name] varchar(50),
[Bank Account No] varchar(50)
)
GO
Insert into tbl_Customer_Bank_Details Values (1,'Imran','A001')
Insert into tbl_Customer_Bank_Details Values (1,'Imran','A002')
Insert into tbl_Customer_Bank_Details Values (1,'Imran','A003')
Insert into tbl_Customer_Bank_Details Values (2,'Bob','B001')
Insert into tbl_Customer_Bank_Details Values (2,'Bob','B002')
GO
Select * from tbl_Customer_Bank_Details


SELECT [Customer ID], [Customer Name]
, STUFF((SELECT ', ' + A.[Bank Account No] FROM tbl_Customer_Bank_Details A
Where A.[Customer ID]=B.[Customer ID] FOR XML PATH('')),1,1,'') As [Bank Accounts]
From tbl_Customer_Bank_Details B
Group By [Customer ID], [Customer Name]

推荐答案

请不要重新发布相同的问题;你已经在上讨论了这个问题，你能开发出这种类型吗？ MS Access中的查询 [ ^ ]。



如果要添加一些细节，请编辑原文。

Please do not repost the same question; you already asked this at can you develop this type of Query in MS Access[^].

If you want to add some detail then edit your original.

这篇关于如何在MS Access中以逗号分隔获取值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！