Hello Every One,
I am working in asp.net application. In which I have a requirement to show records from three tables.
following are my tables
table1: employee
column names: ID, Name, EmailID
table2: project
column names: ID, Date, EmpID, ProjectName
table3: Detail
column names: ID, Date, EmpID, SpentTime, Desc
Now my requirement is that i want following columns from three table using joining
Date, EmpID, ProjectName, Sum(SpentTime)
In these tables for a single date in project table multiple records may be exists. I am not able to getting the records with sum of time when i am retrieving records for a month then it is not returning the sum of single date time instead it returns the sum of time for a full moth.
so please give me SQL query which can help me.