如何在sql server中查询此报告？ [英] How can I do a query for this report in sql server?

问题描述

I have this tables "CashMovementTbl","SalesTbl" & "ExpensesTbl" which include data like that:

http://i.stack.imgur.com/koH6C.jpg [ ^ ]



我想显示以下数据：



http://i.stack.imgur.com/0jPAl.jpg [ ^ ]



那么如何在SQL Server中进行查询以显示这样的数据。

http://i.stack.imgur.com/koH6C.jpg[^]

And I want to show my data such as following:

http://i.stack.imgur.com/0jPAl.jpg[^]

So how can I do a query in SQL Server to show data like that.

推荐答案

查看脚本....

Hi,

Check the Script....

SELECT CM.CashDate, 
	CASE WHEN CM.CashType='IN' THEN S.BillNo ELSE E.ExpnsType END 'Details',
	CASE WHEN CM.CashType='IN' THEN CM.Amount ELSE 0.000 END 'In',
	CASE WHEN CM.CashType='Out' THEN CM.Amount ELSE 0.000 END 'Out'
FROM CashMovementTbl CM
LEFT OUTER JOIN SalesTbl S ON S.SalesID=CM.SalesID
LEFT OUTER JOIN ExpendesTbl E ON E.ExpnsID=CM.ExpenseID

问候，

GVPrabu。

Regards,
GVPrabu.

这篇关于如何在sql server中查询此报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！