I have table called tblFees. The format of the table is





fldMonthID		integer

fldClassID		integer

fldAmount		currency

fldAcademicYearID	Long

fldFeesID		Long



The fldClassId is the primarykey in the tablClass. The format of the 

tblClass is given below



ldClassID

fldCategoryName

fldStandardName

fldDivisionName

fldAcademicYearID

fldStaffID.



Please note that it is not necessary that all fees are applicable to every 

class in the school. Ie Say a fee name "Tuition Fee" may be applicable to a 

particular class but it may not be present in another class.



Could you please suggest a query which will give the following output



1) All FeesIds where Amount is same to all class for all months in a given 

academic Year.

2) All FeesIds Which is same for all the class under a particular Category



Thanks in advance



Anjana















_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.