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 |
|
hacke_02
Starting Member
8 Posts |
 Posted - 2009-05-25 : 12:19:16
|
table A------------------------------------------ID | Name | email | S_ID |------------------------------------------D-01 | XXXX | XXXXXXXXX | S-01 |D-02 | XXXX | XXXXXXXXX | S-02 |D-03 | XXXX | XXXXXXXXX | S-03 |D-04 | XXXX | XXXXXXXXX | S-03 |D-05 | XXXX | XXXXXXXXX | S-04 |D-06 | XXXX | XXXXXXXXX | S-05 |D-07 | XXXX | XXXXXXXXX | S-05 |-------------------------------------------table B------------------------------S-ID | status | salary |------------------------------D-01 | XXXX | 6000 |D-02 | XXXX | 4000 |D-03 | XXXX | 3500 |D-04 | XXXX | 2500 |D-05 | XXXX | 1500 |table C------------------------------ID | date | overtimehour |------------------------------D-02 | 24-oct | 3 |D-03 | 26-oct | 4 |D-03 | 23-oct | 3 |D-04 | 25-oct | 5 |D-04 | 24-oct | 4 |D-05 | 20-oct | 3 |D-05 | 24-oct | 9 |D-05 | 28-oct | 10 |---------------------------Question Is:display A.name, A.email, B.status ,B.sallarynote:ID which has overtime must be overpayand 1 hour multiplied 3%Example:ID = D-04 have double overtime,which has a 9 hour in table Cso his overtime wages is 9 * 3 * 2500 / 100and his sallary in oct month is 2500 + 675some one HELP ME PLEASE, It's So Important, it's the task of school by jj |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-05-25 : 12:28:38
|
| Please don't cross post. No replies to this thread please. Direct replies to: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126389[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
difficul case...