select (select sum(RealAmount) from T_InventorysDetails a where PlanCode='634049554593750000' and PDetailsID=22) as xvalue,* from VIEW_PlansDetailsList b where PDetailsID=22 and PlanCode='TL634049554593750000'
如何让 a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID
如何让 a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID
解决方案 »
- 无法启动SQL2005了.
- 超级简单,把这2个表的数据列表出来
- 郁闷,分没有,语句还是要求啊.
- 有什么办法可以把sql2000默认端口1433改成3322了后,远程连接时不用输端口3322?
- 如何模糊查询某字段以"["(方括号)开头的值,即"columnname like '[%'"的正确写法是什么?
- 请问用一条语句可以实现吗?如果可以,应该怎么写?
- 菜鸟求知:如何在程序中获得Sum()计算的值?
- 请问怎样用一个查询将数据导到EXCEL文件中,而且每天导出到用当天时间命名的EXCEL文件中,用SQL语句怎样写
- 一个很简单的问题,有关于自定义函数的!!
- 用SELECT语句选出某一字段为空的记录的具体语法怎么写?
- 1.1.1,1.1.2此类序号排序问题
- 删除重复行,没自增长主键的表能不能实现?
where a.PlanCode='634049554593750000' and a.PDetailsID=22 and a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID
你的条件是:
a.PlanCode='634049554593750000'
b.PlanCode='TL634049554593750000'然后要求:a.PlanCode=b.PlanCode这是矛盾的,不可能做到这个需求。
where a.PlanCode='634049554593750000' and a.PDetailsID=22 and a.PlanCode=substring(b.PlanCode,3,len(b.PlanCode)) and a.PDetailsID=b.PDetailsID
where a.PlanCode='634049554593750000' and a.PDetailsID=22 and charindex(a.PlanCode,b.PlanCode) > 0 and a.PDetailsID=b.PDetailsID
where a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID) as xvalue,* from VIEW_PlansDetailsList行不?
where a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID) as yvalue/*已领料数量*/,b.Amount-(select sum(RealAmount) from T_InventorysDetails a
where a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID) as svalue/*剩余领料数量*/,* from VIEW_PlansDetailsList b
我还有个问题,如何做到相同的整理一下!
,a.Amount-isnull(b.yvalue,0) as yvalue1
from VIEW_PlansDetailsList a left join (select PlanCode,PDetailsID,sum(RealAmount) as yvalue
from T_InventorysDetails group by PlanCode,PDetailsID) b on a.PlanCode=b.PlanCode and a.PDetailsID=b.PDetailsID