sql - 根据来自单独表的选择查询从另一个表添加列

Question

在这里寻找一些关于将一列数据添加到另一个表中的查询结果的帮助。

所以两张桌子上的关键是customer_number.

我有一个查询如下：

    SELECT [CUSTOMER_NUMBER]
          ,[CUSTOMER_NAME]
          ,count(*) 'YEARS'
    FROM [DB].[dbo].[tablefromxlsimport$]
    group by  [CUSTOMER_NUMBER]
             ,[CUSTOMER_NAME]

这将返回我要从中查找的信息，tableformxlsimport$但我想fullcustomerlist$根据查询结果从另一个表中添加一列数据，该查询将追加一列数据customer_Current_title。

希望我正确解释了这一点

标签： sqlsql-servertsql

Answer 1

请参阅以下查询：

 SELECT
      A.[CUSTOMER_NUMBER]
      ,A.[CUSTOMER_NAME]
      ,A.YEARS
      B.customer_Current_title
 FROM
   ( SELECT 
      A.[CUSTOMER_NUMBER]
      ,A.[CUSTOMER_NAME]
      ,count(*) 'YEARS'

  FROM [DB].[dbo].[tablefromxlsimport$] AS A
  group by  [CUSTOMER_NUMBER]
      ,[CUSTOMER_NAME]
  ) AS A
INNER JOIN dbo.fullcustomerlist$ AS B on A.CUSTOMER_NUMBER = B.CUSTOMER_NUMBER