hai,
this is koti i want to know the dual table for ms access and i send my query for all
but it cant work it will work independently any one sugges solution 
====
select  April_Value - (select April_Value from Sal_Wages_Detail where deductee_id=1246 and Item_Category=2)  from  Sal_Wages_Detail where deductee_id=1246 and  Item_Category=1