按顺序排列select语句 [英] Arranging the select statement in order

问题描述

SELECT COA.acc_code  AS  'Account Code', COA.acc_name  AS  'Account Name', CAST(SUM(debit-credit) AS varchar) AS [$ Debit]
FROM COA  JOIN AccountReceivable
ON COA.acc_name = AccountReceivable.acc_name
WHERE COA.acc_name IN ('Account Receivable')  
GROUP BY COA .acc_code, COA.acc_name

union all

SELECT COA.acc_code  AS  'Account Code', COA.acc_name  AS  'Account Name', CAST(SUM(debit-credit) AS varchar) AS [$ Credit]
FROM COA  JOIN AccountPayable
ON COA.acc_name = AccountPayable.acc_name
WHERE COA.acc_name IN ('Account Payable')  
GROUP BY COA .acc_code, COA.acc_name

我希望我的结果输出类似于第二个表，其中借记值在借方信用值下是信用额度。

I want my result output be like the second table where debit value is under debit credit value is under credit.

Account Code	    Account Name	                Debit
101	            Account Receivable	                200	
200	            Account Payable		       -250

Account Code	    Account Name	                Debit	                Credit
101	            Account Receivable	                               200	
200	            Account Payable		                                           -250

已添加代码块 - OriginalGriff [/ edit]

[edit]Code block added - OriginalGriff[/edit]

推荐答案

借方]
FROM COA JOIN AccountReceivable
ON COA.acc_name = AccountReceivable.acc_name
WH ERE COA.acc_name IN （' 帐户应收款'）
GROUP BY COA .acc_code，COA.acc_name

union all

SELECT COA.acc_code AS ' 帐户代码，COA.acc_name AS ' 帐户名称，CAST（SUM（借方贷方） AS varchar ） AS

Debit] FROM COA JOIN AccountReceivable ON COA.acc_name = AccountReceivable.acc_name WHERE COA.acc_name IN ('Account Receivable') GROUP BY COA .acc_code, COA.acc_name union all SELECT COA.acc_code AS 'Account Code', COA.acc_name AS 'Account Name', CAST(SUM(debit-credit) AS varchar) AS

Credit]
FROM COA JOIN AccountPayable
ON COA.acc _name = AccountPayable.acc_name
WHERE COA.acc_name IN （' 应付帐款'）
GROUP BY COA .acc_code，COA.acc_name

Credit] FROM COA JOIN AccountPayable ON COA.acc_name = AccountPayable.acc_name WHERE COA.acc_name IN ('Account Payable') GROUP BY COA .acc_code, COA.acc_name

我希望我的结果输出像第二个表借方价值低于借方贷方的信用额度在信用额度下。

I want my result output be like the second table where debit value is under debit credit value is under credit.

Account Code	    Account Name	                Debit
101	            Account Receivable	                200	
200	            Account Payable		       -250

Account Code	    Account Name	                Debit	                Credit
101	            Account Receivable	                               200	
200	            Account Payable		                                           -250

[edi t]添加了代码块 - OriginalGriff [/ edit]

[edit]Code block added - OriginalGriff[/edit]

在UNION语句中，您不能为列提供两个不同的名称（这里我说的是

You cannot, in an UNION statement, give two different names to a column (here I''m talking about the

这篇关于按顺序排列select语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！