sql - 用sql连接表

Question

我有两张 table 我想加入。一个包含客户，名为“客户”。另一个表“Customeraccounts”。这些表与客户 ID 相关。像这样。

Customers
1, john, Smith

CustomerAccounts
1, 1, 12345678
2, 1, 98765432

我如何将表加入输出将是:

1, john, smith, 12345678, 98765432

Answer 1

也许这对你有用:

SELECT Customers.Id, 
       Customers.LastName, 
       Customers.FirstName,
       STUFF((SELECT ',' + CustomerAccounts.Number
              FROM CustomerAccounts
              WHERE CustomerAccounts.CustomerId = Customers.Id
         FOR XML PATH('')
        ),1,1,'') 
       AS AllCustomerAccounts   
FROM Customers