plz help me in dis query...

[jenipriya]

how to write a query to calculate the salary deduction for an employee in a given dept for a given month?
salary deduction is
sum of Clubfees(from club table) + SAL(from employee table/30 * no of leaves taken for that month (from leave table)...
in leave table only DateOfLeave column s there.. how to calculate leave taken for that month and how to use in dis query?

[debasisdas]

Since you had posted a question in Article section it it being moved to Oracle forum.

[debasisdas]

can you kindly post structure of all of your tables please for my reference.

[jenipriya]

Employee (EmpID, EmpName,DeptID DateOfJoin, Sal, Addr)
Finance (EmpID, Sal)
Club (Clubname, EmpID, Fee, DateOfJoin)
Leave (EmpID, Date)
Department (DeptID, DeptName, NoOfEmployees)


dis s the table structure i have...

[jenipriya]

Its urgent could u please help me to find the salary deductions