Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cool.mugil
Starting Member
32 Posts |
 Posted - 2009-03-20 : 11:37:11
|
| Hi,I has three tables.Employee which has ID,NameAttendance EmpID,Date,Status [Has multiple entry for employee]Loan EmpID,Type,Amount [Has multiple entry for employee]I want to get the Sum of attendance date,sum of loan amount for each employee.How can i do this without using subqueries and by using joins.Is there any way.Please guide me.i am using sql server 2005Thanks in advance. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-03-20 : 11:39:53
|
| Sum of date?? |
 |
|
|
cool.mugil
Starting Member
32 Posts |
Posted - 2009-03-20 : 11:42:01
|
| hi,Sorry.It's not sum of date.It's count of present days. |
|
|
|
cool.mugil
Starting Member
32 Posts |
Posted - 2009-03-20 : 11:47:00
|
| No,it's sample application. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-20 : 11:57:06
|
| did nt understand the purpose of second part. why dont you want to use subqueries & joins? |
|
|
|
|
|
|
Joins