mysql - 未知的内部查询错误

Question

我有下面的脚本在内部查询中抛出错误。我使用 Sequel Pro 并且只收到此错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Savings FROM OfferSuggestionHeader osh LEFT JOIN Projects p ON osh.OfferI' at line 2

所以我不确定实际问题是什么。我尝试在内部查询中进行显式内部连接，以防 p 别名未被正确引用/解释或类似情况，但这没有产生积极影响。

SELECT SUM(osh.Savings) as YTD, 
   SUM (SELECT Savings
FROM OfferSuggestionHeader osh
LEFT JOIN Projects p
ON osh.OfferID = p.offer_id
WHERE p.uid = 1 AND p.current_status < 3) 
   AS "Open Savings"
FROM OfferSuggestionHeader osh
LEFT JOIN Projects p
    ON p.offer_id = osh.OfferID
WHERE p.uid = '1'

感谢任何帮助。最好的，

Answer 1

我认为您可以更简单地编写查询:

SELECT SUM(osh.Savings) as YTD,
       SUM(case when p.current_status < 3 then Savings end) AS "Open Savings"
FROM OfferSuggestionHeader osh LEFT JOIN
     Projects p
     ON p.offer_id = osh.OfferID
WHERE p.uid = '1'

也就是说，您可以将子查询完全替换为条件求和。