gpt4 book ai didi

mysql - 连接两个包含一个 WHERE 子句的 MySQL SELECT 语句

转载 作者:行者123 更新时间:2023-11-30 22:29:29 25 4
gpt4 key购买 nike

如何将下面的两个 select 语句合并为一个语句?我希望结果出现在一张表中。感谢您的帮助。

第一条声明-

SELECT Account_ID, SUM(Profit_Loss) AS Starting_Balance
FROM client_ledger_history
WHERE Summary = 'Cash In'
GROUP BY Account_ID WITH ROLLUP

第二个声明 -

SELECT
client_ig_client_list.Account_ID,
client_ig_client_list.`Name`,
Share_Status,
Forex_Status,
Index_Status,
Share_Weighting,
Forex_Weighting,
Index_Weighting,
SUM(
client_ledger_history.Profit_Loss
) AS Current_Balance
FROM
client_ledger_history
LEFT JOIN client_ig_client_list ON client_ig_client_list.Account_ID = client_ledger_history.Account_ID
GROUP BY
Account_ID WITH ROLLUP

最佳答案

您应该连接到嵌套表中

SELECT
client_ig_client_list.Account_ID,
Starting_Balance,
client_ig_client_list.`Name`,
Share_Status,
Forex_Status,
Index_Status,
Share_Weighting,
Forex_Weighting,
Index_Weighting,
SUM(client_ledger_history.Profit_Loss) AS Current_Balance
FROM
client_ledger_history LEFT JOIN client_ig_client_list ON client_ig_client_list.Account_ID = client_ledger_history.Account_ID
LEFT JOIN
(SELECT Account_ID, SUM(Profit_Loss) AS Starting_Balance
FROM client_ledger_history WHERE Summary = 'Cash In' GROUP BY Account_ID WITH ROLLUP) as client_ledger_aggreagated_history
ON client_ledger_aggreagated_history.Account_ID = client_ledger_history.Account_ID
GROUP BY Account_ID WITH ROLLUP

关于mysql - 连接两个包含一个 WHERE 子句的 MySQL SELECT 语句,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/34250904/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com