我想将数据从一个表插入到另一个表。条件是,如果第一个表仅具有记录,那么只有该记录我需要插入到另一个表中。
我正在尝试查询:
INSERT INTO Customer_Map_Address(CustomerID, AddressID, IsBillingAddress)
SELECT [CustomerID], [ID], CAST('FALSE' as BIT) AS IsBillingAddress
FROM CustomerAddress Group By CustomerID, ID
having COUNT(CustomerID) = 1
它按客户ID和ID分组,因此输出错误。我只想按客户ID分组。
谢谢。
INSERT INTO dbo.Customer_Map_Address (CustomerID, AddressID, IsBillingAddress)
SELECT [CustomerID], MAX([Id]), 0 AS IsBillingAddress
FROM dbo.CustomerAddress
GROUP BY CustomerID
HAVING COUNT(*) = 1
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句