Tech Support Forum banner
Not open for further replies.
1 - 1 of 1 Posts

· Registered
4 Posts
Discussion Starter · #1 ·
Dear Sir,

We have to tables like the staff table and the staff salary table
The staff table contains the details like the
Staff ID (PK)
Staff name
Currently Working (Yes/ No)

And the staff salary table contains the salary month, staff id, basic Salary, over time allowances and the total amount to be paid..

We need to do the follwing

When we select a particular month all the staff id and the staff name who are currently working has to be displayed in rows like the below form

No Staff Name Staff ID Basic Salary Overtime Allowance Total Amount
1 KKKKK 123 2000 1000 3000
2 YYYYYY 101 2200 100 2300

Please advise how to do the same....
1 - 1 of 1 Posts
Not open for further replies.