使用左外连接加入两个mysql结果集

1 回答

• 1

  尝试这样的事情，

  SELECT  a.InvoiceID,
          a.totalSum InvoiceAmount,
          b.totalSum PaymentAmount,
          a.totalSum - COALESCE(b.totalSum, 0) TotalBalance
  FROM
      (
          SELECT  InvoiceID, SUM(Total) totalSum
          FROM    InvoiceTB
          GROUP BY InvoiceID
      ) a LEFT JOIN
      (
          SELECT  InvoiceID, SUM(Total) totalSum
          FROM    paymentTB
          GROUP BY InvoiceID
      ) b
          ON a.InvoiceID = b.InvoiceID
  

  回复于 2024-04-28T18:00:42+08:00