1樓：小卒
SELECT AB.subject_code code, AB.subject_name name
, IFNULL(AB.debit_amount_init, 0) debit_amount_init
, IFNULL(AB.credit_amount_init, 0) credit_amount_init
, IFNULL(AB.debit_amount_curr, 0) debit_amount_curr
, IFNULL(AB.credit_amount_curr, 0) credit_amount_curr
, IFNULL(C.debit_amount_end, 0) debit_amount_end
, IFNULL(C.credit_amount_end, 0) credit_amount_end
, IFNULL(D.debit_amount_total, 0) debit_amount_total
, IFNULL(D.credit_amount_total, 0) credit_amount_total
FROM
(SELECT B.subject_code, B.subject_name
, A.debit_amount_init, A.credit_amount_init
, B.debit_amount_curr, B.credit_amount_curr
FROM
(SELECT subject_code
, subject_name
, SUM(debit_amount) debit_amount_init
, SUM(credit_amount) credit_amount_init
FROM accounting_document_item adi, accounting_document ad
WHERE adi.doc_id = Domain Premium: ad.id
AND date_format(accounting_date, '%Y%m') < CONCAT(@12-YEAR@, @12-MONTH@)
GROUP BY subject_code, subject_name) A
RIGHT JOIN
(SELECT subject_code
, subject_name
, SUM(debit_amount) debit_amount_curr
, SUM(credit_amount) credit_amount_curr
FROM accounting_document_item adi, accounting_document ad
WHERE adi.doc_id = Domain Premium: ad.id
AND date_format(accounting_date, '%Y%m') = CONCAT(@12-YEAR@, @12-MONTH@)
GROUP BY subject_code, subject_name) B
ON A.subject_code = B.subject_code) AB
LEFT JOIN
(SELECT subject_code
, subject_name
, SUM(debit_amount) debit_amount_end
, SUM(credit_amount) credit_amount_end
FROM accounting_document_item adi, accounting_document ad
WHERE adi.doc_id = Domain Premium: ad.id
AND date_format(accounting_date, '%Y%m') <= CONCAT(@12-YEAR@, @12-MONTH@)
GROUP BY subject_code, subject_name) C
ON AB.subject_code = C.subject_code
LEFT JOIN
(SELECT subject_code
, subject_name
, SUM(debit_amount) debit_amount_total
, SUM(credit_amount) credit_amount_total
FROM accounting_document_item adi, accounting_document ad
WHERE adi.doc_id = Domain Premium: ad.id
AND date_format(accounting_date, '%Y') = @12-YEAR@
GROUP BY subject_code, subject_name) D
ON AB.subject_code = D.subject_code
我知道我貼出來的肯定不算長的，
拋磚引玉
據說現在可以只需要開啟瀏覽器，寫寫 SQL 就能一站完成系統開發了: https://
enhancer.io
請各位大佬們談談出國留學的看法？
葉落山路 很少在知乎上回答問題，最近得閒也來湊湊熱鬧。目前我在國外留學半年多，體驗也比較粗淺。總體上講，你可以過的很興奮也可以過的很虛度。既然是留學，我想當然要關注 學 其實很多優秀大學的課程是很有挑戰性的，想學好不是一件輕鬆的事，所以不論從學習方法和心態上都需要做比較大的調整。要習慣失敗，並且再抖...
seo大牛們，想問問你們剛開始學習的時候是什麼樣子的？
Lance 找對乙個師傅，跟著做很重要，很多技術白瞟是漂不到的，需要付出些財力，白瞟永遠都只能在淺顯的位置等待，seo技術靠的是圈子，沒人帶入門永遠進不圈。如果實在沒辦法，那就簡單點找文章研讀，讀了大部分文章也就知道seo決定因素是哪些 然後通過決定因素再乙個乙個深究，鑽研，畢竟搜尋引擎本來就在那裡...
你們寫過或讀過的最可愛最溫柔的句子是什麼？
1 即使到最後的遍體鱗傷，我也會微笑著守著你對我的好，因為，我想一生銘記。2 抱怨，是一種負能量，猶如搬起石頭砸自己的腳，於人無益，於己不利，於事無補。3 夜有多冷，只有整夜不睡的人才知道。心會有多痛，只有痛過的人才知道。4 每天努力再多一點，每天堅持再久一點，你會發現很多事情沒有那麼困難。5 你今...