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 |
|
chiragvm
Yak Posting Veteran
65 Posts |
 Posted - 2007-04-26 : 01:07:01
|
| hi to all i have one confusion about select query in query have two table 1) = eid, name, surmame, day, month, leve (empmaster)2) = did, eid, month,leve (empdetail)here is two table fields i lost data of empdetail so i want to one select query witch return me a summery of data like eid month leve 1 1 51 2 82 6 93 7 8please help me |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-26 : 01:10:39
|
quote:
i lost data of empdetail
Does that mean there is no data in empdetail table? Also why month, leave columns are repeated both in empmaster and empdetail? If there is no data in empdetail, why do you want to consider that as a part of query?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-26 : 01:33:01
|
| select eid, month, sum(leve) as leve from empmaster group by eid, month order by eid, monthPeter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
Select query