我有账户和子账户的概念。
Account
|--->Subaccount1
|----> Subaccount2
|---->Subaccount3
....................... and so on
Account level rest url's:
POST - base_url/accounts
PUT - base_url/accounts
GET - base_url/accounts/$acc_name
DE
使用SUM的此子查询有问题。该查询将对特定日期范围内的几条记录的利润列进行总计。我将根据记录所附的账号对这一总利润进行分组。只有一个帐号,它就能正常工作:
select
[ACCOUNT ID],
(
select SUM(PROFIT)
from [Transaction Table]
where [ACCOUNT ID] in ('1001')
and [ACTIVITY DATE] in ('5/31/2012')
) as 'May Profit'
from
[Tr