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?