如何在SQL中解析字段列表中的列？

发布于 2025-02-10 00:38:44 字数 441 浏览 1 评论 0原文

我想加入我的桌子product_sales和产品。但是，产品编号似乎是模棱两可的。以下是我的代码，请帮助我在哪里弄错了。谢谢

INSERT INTO HSD_DW.PRODUCT_SALES
SELECT UNIX_TIMESTAMP(TimeID) AS TimeID, CustomerID, ProductNumber,
       SUM(Quantity) AS TotalQty, UnitPrice, SUM(Quantity) * UnitPrice AS Total
FROM HSD.PRODUCT_SALES AS PS
INNER JOIN hsd.product AS P ON PS.ProductNumber = P.ProductNumber
GROUP BY TimeID, CustomerID, ProductNumber, UnitPrice
ORDER BY TimeID;

原文

I wanted to join my tables product_sales and product. However, the product number seemed to be ambiguous. The following are my codes, kindly help me where I got it wrong. Thank you

INSERT INTO HSD_DW.PRODUCT_SALES
SELECT UNIX_TIMESTAMP(TimeID) AS TimeID, CustomerID, ProductNumber,
       SUM(Quantity) AS TotalQty, UnitPrice, SUM(Quantity) * UnitPrice AS Total
FROM HSD.PRODUCT_SALES AS PS
INNER JOIN hsd.product AS P ON PS.ProductNumber = P.ProductNumber
GROUP BY TimeID, CustomerID, ProductNumber, UnitPrice
ORDER BY TimeID;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

糖果控 2025-02-17 00:38:44

放置“ PS。”参考“ ProductNumber”列之前。

    INSERT INTO HSD_DW.PRODUCT_SALES
    SELECT UNIX_TIMESTAMP(TimeID) AS TimeID, CustomerID, PS.ProductNumber,
           SUM(Quantity) AS TotalQty, UnitPrice, SUM(Quantity) * UnitPrice AS Total
    FROM HSD.PRODUCT_SALES AS PS
    INNER JOIN hsd.product AS P ON PS.ProductNumber = P.ProductNumber
    GROUP BY TimeID, CustomerID, PS.ProductNumber, UnitPrice
    ORDER BY TimeID;

Place "PS." before reference "ProductNumber" column.

    INSERT INTO HSD_DW.PRODUCT_SALES
    SELECT UNIX_TIMESTAMP(TimeID) AS TimeID, CustomerID, PS.ProductNumber,
           SUM(Quantity) AS TotalQty, UnitPrice, SUM(Quantity) * UnitPrice AS Total
    FROM HSD.PRODUCT_SALES AS PS
    INNER JOIN hsd.product AS P ON PS.ProductNumber = P.ProductNumber
    GROUP BY TimeID, CustomerID, PS.ProductNumber, UnitPrice
    ORDER BY TimeID;

回复收藏 0 原文

~没有更多了~