我正在尝试进行计算并在select语句内填充一个字段。看起来像这样:
CREATE VIEW SALES_REPORT AS(
SELECT
INVOICENO,
INVOICEDATE,
CLIENTID,
CONTACT,
INVOICEJOBNO,
ADDCHARGES,
CHARGESINFO,
EMPLOYEEID,
USUALPAY,
VAT,
SUBTOTAL (SELECT(USUALPAY * COUNT(*) AS SUBTOTAL FROM SALES_REPORT)),
TOTAL = (SUBTOTAL * VAT)
FROM SALES_REPORT_JOINS_CONFIG
GROUP BY INVOICENO ORDER BY INVOICEDATE DESC);
任何帮助将是巨大的,谢谢!
最佳答案
TOTAL = (SUBTOTAL * VAT)
应该是
(SUBTOTAL * VAT) AS TOTAL
现在,它将返回相等比较的布尔值true / false。您没有将乘法结果分配给“总计”字段,而是将总值与乘法结果进行比较。
这是一个完全语法错误:
SUBTOTAL (SELECT(USUALPAY * COUNT(*) AS SUBTOTAL FROM SALES_REPORT)),
关于mysql - 在选择语句中填充字段-MySQL,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/13711506/