Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
SELECT tblClient.[name] as ClientName , tblProject.[Name] as ProjectName , tblEmployee.[Name] as EmployeeName , Date ,Timespent ,SUM(Timespent) as Totaltimespent, Task ,EmployeeID,tblTimesheet.ID as ID FROM tblTimesheet INNER JOIN tblProject on tblTimesheet.ProjectID = tblProject.ID INNER JOIN tblEmployee on tblTimesheet.EmployeeID = tblEmployee.ID INNER JOIN tblClient on tblProject.ClientID = tblClient.ID WHERE ProjectID=@ProjectID AND tblProject.ClientID =@ClientID