如何在已经存在数学运算的地方编写SQL连接 [英] How to write a SQL join where already exists a mathematical operation

问题描述

select SUM([DC_Bill]) FROM [Bill_Details] where [CustomerID]=''1''


select * from Customer_Details where [CustomerID]=''1''

How do i join these two?

推荐答案

您的解决方案在这里:

Your Solution is here:

SELECT CD.*,BD.DC_BILL
FROM CUSTOMER_DETAILS CD
    LEFT JOIN (SELECT CUSTOMERID,SUM([DC_BILL]) AS [DC_BILL] FROM BILL_DETAILS GROUP BY CUSTOMERID) BD
        ON CD.CUSTOMERID = BD.CUSTOMERID
WHERE CD.[CUSTOMERID]='1'

这篇关于如何在已经存在数学运算的地方编写SQL连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！