内部连接的Querry问题 [英] Problem in querry for inner join

问题描述

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屋！