内部连接的Querry问题 [英] Problem in querry for inner join
本文介绍了内部连接的Querry问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Hi,
employee table-
employeeid,employeename,departmentid
timesheet table-
employeeid,startdate,enddate,hourstaken,departmentid
departmentactivity tabel-
departmentid,activityname
当我插入开始日期,结束日期和否时,我也想要活动名称.小时.
我正在使用此查询,可以在没有时间的情况下正常工作.
i want activity name also when i insert startdate,enddate and no. of hours.
i am using this queery it works fine for getting no of hours .
SELECT e.employeename,convert(VARCHAR, t.startdate, 111) as startdate,SUM(t.hourstaken) as hourstaken
FROM employee e INNER JOIN timesheet t ON e.employeeid=t.employeeid where convert(VARCHAR, t.startdate, 111) = '2012/04/10'
GROUP BY e.employeeid,e.employeename,convert(VARCHAR, t.startdate, 111) HAVING SUM(t.hourstaken) < 7 order by e.employeename
在此先感谢
Thanks in Advance
推荐答案
SELECT
e.employeename
,CONVERT(VARCHAR, t.startdate, 111) as startdate
,SUM(t.hourstaken) as hourstaken
,d.activityname
FROM
employee e
INNER JOIN timesheet t ON e.employeeid = t.employeeid
INNER JOIN departmentactivity d ON e.departmentid = d.departmentid
WHERE
CONVERT(VARCHAR, t.startdate, 111) = '2012/04/10' --2012, October 4th
GROUP BY
e.employeeid
,e.employeename
,CONVERT(VARCHAR, t.startdate, 111)
,d.activityname
HAVING
SUM(t.hourstaken) < 7
ORDER BY
e.employeename
这篇关于内部连接的Querry问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文