select ProjectActionNode.StatusID from ProjectActionNode where( ProjectActionNode.ProjectID=47 and ProjectActionNode.ActionNode=
(select c."ID" from ActionNode c where
(c.PreStatusID=(select d.StatusID from Project d where d."ID"=47 )
and c.ID in(select ActionNodeID from ProjectActionNode where ProjectActionNode.StatusID=2)
and c.ActionID in
( select a.ActionID from FlowNode a where( a."ID" in
(select b.FlowNodeID from ProjectFlowNode b where b.ProjectID=47) and SubjectRoleID=4)))
group by c."ID")
group by ProjectActionNode.StatusID
服务器: 消息 156,级别 15,状态 1,行 9
在关键字 'group' 附近有语法错误。
这是咋回事呀!??那位兄弟受累给看看!!!:)
解决方案 »
- Repeater 绑定
- 算法问题(递归)
- Access 2003 是否支持分布式事务管理?(COM+)
- 请问下在vs2005如何生成表格
- SQL语言如何让“字母+数字”的数据按“数字”排序?
- 请问怎样做?
- 帮忙提供(MSDN2003中文版)下载“非常感谢”
- 在DataGrid1_ItemCommand事件中提交Delete后,我想刷新DataGrid1,这样使刚删除的行就不再显示,但是重新绑定发先一次删除了2行??
- 一个简单的问题,怎样通过button的单机事件来改变整张网页的bgcolor?
- 绑定的datagrid如何链接2个以上的参数?以及,datagrid下面显示1,2,3..这些数字分页怎么让它起作用?
- Inser Into Table问题
- 如何写这样的脚本
否则遇到这种多层的Sql肯定挂。
from ProjectActionNode
where ProjectActionNode.ProjectID=47 and ProjectActionNode.ActionNode=
(
select c."ID" from ActionNode c
where
(c.PreStatusID=(select d.StatusID from Project d where d."ID"=47 )
and c.ID in(select ActionNodeID from ProjectActionNode where ProjectActionNode.StatusID=2)
and c.ActionID in
(select a.ActionID from FlowNode a
where
( a."ID" in (select b.FlowNodeID from ProjectFlowNode b where b.ProjectID=47)
and SubjectRoleID=4
)
)
)
group by c."ID"
)
group by ProjectActionNode.StatusID
让俺也提高以下!!!:)
from ProjectActionNode
where ProjectActionNode.ProjectID=47 and ProjectActionNode.ActionNode=
(
select c."ID" from ActionNode c
where
(c.PreStatusID=(select d.StatusID from Project d where d."ID"=47 )
and c.ID in(select ActionNodeID from ProjectActionNode where ProjectActionNode.StatusID=2)
and c.ActionID in
(select a.ActionID from FlowNode a
where
( a."ID" in (select b.FlowNodeID from ProjectFlowNode b where b.ProjectID=47)
and SubjectRoleID=4
)
)
)
group by c."ID"
)
group by ProjectActionNode.StatusID