Hi Please use the following query and if you are getting any error then first check the join condition because u are saying that empid is the PK, but I didnot found in either of the table, secondly you might get an error in the where clause because the spelling of employye_id is do not match in the where condition it is employee_id here.Either it sould be employye_id in place or employee_id
select isnull(sum(paydrawn.pay),0) as pay,
isnull(sum(paydrawn.ppay),0) as ppay, isnull(sum(paydrawn.dpay),0) as dpay,
isnull(sum(paydrawn.da),0) as da, isnull(sum(paydrawn.hra),0) as hra,
isnull(sum(paydrawn.cca),0) as cca, isnull(sum(paydrawn.ma),0) as ma,
isnull(sum(paydrawn.eve),0) as eve,
isnull(sum(paydrawn.el_surrender),0) as el_surrender,
isnull(sum(paydrawn.da_arrears),0) as da_arrears,
isnull(sum(paydrawn.other_arrears)+sum(paydrawn.bonus),0) as others,
------------- tax.sno, tax.employee_id, tax.year, tax.gross_income,
tax.less_allowance, tax.balance, tax.prof_tax, tax.mediclaim,
tax.donation, tax.interest_education , tax.aggregatee ,
tax.income_chargeable , tax.jeevan , tax.lic_salary , tax.lic_private ,
tax.pli_salary , tax.pli_private , tax.gpf , tax.groupp , tax.spf ,
tax.nss , tax.nsc , tax.nsc_interest , tax.ppf , tax.uti , tax.ulip ,
tax.hblp , tax.da_gpf , tax.tution , tax.icici , tax.total ,
tax.restricted1 , tax.restricted2 , tax.rental_income , tax.municipal_tax ,
tax.water_tax , tax.repairs , tax.interest_loan , tax.insurance ,
tax.housing1 , tax.housing2 , tax.taxable_income , tax.tax_on ,
tax.surcharge , tax.tax_liability , tax.tax_recovered , tax.tax_payable ,
tax.to_day, ----------- employee.sno, employee.employye_id,
employee.name, employee.dob, employee.doj, employee.gpf, employee.pan,
employee.specialization, employee.institution, employee.dept,
employee.category, employee.designation from paydrawn
INNER JOIN tax_details tax ON paydrawn.empid = tax.empid INNER JOIN employee
ON paydrawn.empid = employee.empid
where (paydrawn.month>=3 and paydrawn.year=2011) or (paydrawn.month<3 and paydrawn.year=2012)
AND tax.employee_id=101 and tax.year='2011-2012' AND employee.employee_id=101
