看了一下,不知道楼主是不是这个意思:
select sum(Score) as ka from RecordDrawScore where DrawID in (select KindID from GameScoreInfo where KindID > 2000)
select sum(Score) as ka from RecordDrawScore where DrawID in (select KindID from GameScoreInfo where KindID > 2000)
解决方案 »
- 可不可以建一个winform,像messagebox一样的?
- 如何验证sqlserver数据库中是否存在某用户
- 在XML文件中如何做類似SQL中的SUM()方法
- winform调用webservice问题
- 运行时,控件的选择、拖动问题!
- 怎样把一个交差表保存到另一个表里?(我把最后的分都拿来问了。)
- 帮我 ping 一下这个地址
- 关于文件上传问题,大家都使用htmlcontrols.htminputfile控件吗?
- 在dataGrid的单击DataGridBoolColumn的单元格的问题.
- 请问c#如何调用win10的edge引擎
- C# winform为什么界面总死掉?
- 在线等,数据库连接问题
inner join GameScoreInfo as B on A.DrawID = B.DrawID
where B.KindID > 2000
majiangrint = 0;
majiangrint1 = 0;
DataTable m_mdt = myData.GetDataTable("select sum(A.Score) as ka from RecordDrawScore as A inner join GameScoreInfo as B on A.DrawID = B.DrawID where B.KindID > 2000 and userID=(select UserID from QPAccountsDB.dbo.AccountsInfo where Accounts='" +id + "') and [InsertTime] >= '" + d1 + " 12:00:00' and [InsertTime] <= '" + d2 + " 12:00:00'");
if (m_mdt != null)
我想查询RecordDrawScore Score的和,条件是要GameScoreInfo里DrawID对应的KindID 的值必须大于2000的才进入求和计算
select sum(Score) as ka from RecordDrawScore where DrawID in (select DrawID from GameScoreInfo where KindID > 2000)