Khalil Islamzada
Registered User.
- Local time
- Today, 09:53
- Joined
- Jul 16, 2012
- Messages
- 49
Dear all;
I have made a database for salary payments and I want to add the salary advance/loan to this database, so what i did is as follow;
Table for staff ID
Table for staff salaries
Month
Year
....
For the salaries I don't have problem,but
1. I have a table for salaries which contain salary, over time, bonus .... and salary advance deduction which is joined with staff ID.
2. I have a table for salary advance payment which is also joined with staff ID.
Now I want to make a query that from staff ID list, I calculate salary advance payment from table (2.salary advance) and salary advance deduction from table (1. staff salary advance deduction) to find the balance of each staff,
Hope I can transfer my question and you get it!:banghead:
I have made a database for salary payments and I want to add the salary advance/loan to this database, so what i did is as follow;
Table for staff ID
Table for staff salaries
Month
Year
....
For the salaries I don't have problem,but
1. I have a table for salaries which contain salary, over time, bonus .... and salary advance deduction which is joined with staff ID.
2. I have a table for salary advance payment which is also joined with staff ID.
Now I want to make a query that from staff ID list, I calculate salary advance payment from table (2.salary advance) and salary advance deduction from table (1. staff salary advance deduction) to find the balance of each staff,
Hope I can transfer my question and you get it!:banghead: