主页 / dba / 问题 / 58673
Accepted
BuZZ-dEE
Asked: 2014-02-12 10:42:54 +0800 CST

从 SQL 中的 SELECT 中减去值

  • 772

我有以下两个查询：

  1. shipManagementInvoiceNetValue：

    SELECT IFNULL (SUM (shipManagementInvoice.netto ), 0) AS shipManagementInvoiceNetValue
FROM tckopf AS shipManagementInvoice
WHERE shipManagementInvoice.referenzid = 1
    AND shipManagementInvoice.btyp = 5

  2. shipManagementCreditNoteNetValue：

    SELECT IFNULL (SUM (shipManagementCreditNote.netto), 0) AS shipManagementCreditNoteNetValue
FROM tckopf AS shipManagementCreditNote
WHERE shipManagementCreditNote.referenzid = 1
    AND shipManagementCreditNote.btyp = 6

但我需要结果shipManagementInvoiceNetValue - shipManagementCreditNoteNetValue。我使用的HXTT JDBC DBF 驱动程序支持的不仅仅是 SQL92。

我怎么能意识到这一点？

foxpro xbase

1 个回答

  1. Best Answer

    尝试这个..

    SELECT X.shipManagementInvoiceNetValue - Y.shipManagementCreditNoteNetValue
FROM 
(
   SELECT IFNULL (SUM (shipManagementInvoice.netto ), 0) AS shipManagementInvoiceNetValue
   FROM tckopf AS shipManagementInvoice
   WHERE shipManagementInvoice.referenzid = 1
   AND shipManagementInvoice.btyp = 5
)X,
(
   SELECT IFNULL (SUM (shipManagementCreditNote.netto), 0) AS shipManagementCreditNoteNetValue
   FROM tckopf AS shipManagementCreditNote
   WHERE shipManagementCreditNote.referenzid = 1
   AND shipManagementCreditNote.btyp = 6
)Y
    • 2

相关问题