select U.UserName,S.BasicSalary,(select sum(SalesNumber) from SalesTable where UserID=1)as
counter,Z.SalaryDownList,Z.SalaryUpList,Z.SalaryRate,
S.BasicSalary+5*Z.SalaryRate as Reault--这样既可
from dbo.UserList as
U inner join dbo.SalaryTable as S on S.UserID=U.UserID
inner join dbo.SalesTable as T on T.UserID=U.UserID inner join SalaryClassify as Z on
(select sum(SalesNumber) from SalesTable where UserID=1) between SalaryDownList and
SalaryUpList
counter,Z.SalaryDownList,Z.SalaryUpList,Z.SalaryRate,
S.BasicSalary+5*Z.SalaryRate as Reault--这样既可
from dbo.UserList as
U inner join dbo.SalaryTable as S on S.UserID=U.UserID
inner join dbo.SalesTable as T on T.UserID=U.UserID inner join SalaryClassify as Z on
(select sum(SalesNumber) from SalesTable where UserID=1) between SalaryDownList and
SalaryUpList
解决方案 »
- 最简短替换语句
- 如何把系统存储过程运行出来的结果插入一张表的某些字段中?
- 数据库连接串中加Application Name问题
- 我的SQL语句为何使用了DISTINCT却没有过滤掉相同的记录??
- 时间类型问题?
- 请求高手们支援ASP网站程序的问题!www.88857688.cn
- 关于一个简单问题
- 我特别喜欢北京,因此从新疆某大学毕业就来这里了,可能是我来的不是时候,我去的雍和宫、东城区等地方的定期人才招聘会,没有发现有招软件开发的。我擅长数据库开发,用的是SQL Server,delphi。请教大师们我应该怎么找工作?谢谢!!
- 我要做一个SQL脚本用来insert记录,其中对datetime字段如何处理?sos
- SQL如何使两个select语句查询结果合并一个?
- 怎么才能让列不能重复啊 急!!!急!!!急!!!
- 中文查询出来是乱码
counter,Z.SalaryDownList,Z.SalaryUpList,Z.SalaryRate,
S.BasicSalary+5*Z.SalaryRate as Reault
from dbo.UserList as
U inner join dbo.SalaryTable as S on S.UserID=U.UserID
inner join dbo.SalesTable as T on T.UserID=U.UserID inner join SalaryClassify as Z on
(select sum(SalesNumber) from SalesTable where UserID=1) between SalaryDownList and
SalaryUpList
(select sum(SalesNumber) from SalesTable where UserID=1) as counter,
Z.SalaryDownList,Z.SalaryUpList,Z.SalaryRate,
S.BasicSalary+5*Z.SalaryRate
from dbo.UserList as U
inner join dbo.SalaryTable as S on S.UserID=U.UserID
inner join dbo.SalesTable as T on T.UserID=U.UserID
inner join SalaryClassify as Z on
(select sum(SalesNumber) from SalesTable where UserID=1)
between SalaryDownList and SalaryUpList