作者TCH (最无价值单身汉)
看板Database
标题Re: [SQL ] 两个SQL语法要合并写在一起
时间Wed Sep 5 20:48:13 2007
以下是我胡乱试出来的，请参考...
string sqlStr = "select EM.StuName ,
sum(datediff(hh,SP.StartTime,SP.EndTime) as Times, ";
sqlStr += "sum(datediff(hh,SP.StartTime,SP.EndTime))*5400 as Bonus ";
sqlStr += "from Student as EM left join Spell as SP ";
sqlStr += "on SP.SpellStuID in ";
sqlStr += "( ";
sqlStr += " select SP2.SpellStuID ";
sqlStr += " from Spell as SP2 ";
sqlStr += " where EM.StuID = SP2.SpellStuID and YearMonth = '" + YearMonth
+"' ";
sqlStr += ") ";
sqlStr += "where EM.UnitID = '" + ClassID.Substring(0, 3) + "' ";
sqlStr += "group by EM.StuName ";
头好痛...... ><"
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.137.101.19