sqlquery

Question

i have 3 tables 1st contains regnostudnameclassidparentaddress- named registration . 2nd contains classidclassnamefees etc named class. 3rd contains feeidregidclassidfeedatetotal -named fee. i want to select at tne end of month list of student whose are not paid the fee. select regnostudnameclassnameparentaddress from both registration and class whose are not paid the fee in the corresponding date? plz help.

Ankit Nandekar · Answer

try this SELECT Reg.regidReg.studname [Student Name] Reg.parents Reg.address cls.classname [Class] FROM dbo.registration Reg INNER JOIN dbo.class cls ON cls.classid=Reg.classid INNER JOIN dbo.fee f ON f.classid=cls.classid group by Reg.regidReg.studname Reg.parents Reg.addresscls.classnamefeedate having DATEDIFF (ddfeedategetdate())>20 and avg(total)-sum( cls.fees)>0 here i take fees fiels as a paidfees and toatal fees as a total class fees.

Vijay Yadav · Answer

Hi Shyja for that you have to take Date/Month column in the registration table so that you can get appropriate result and you have to fired join query for ex: select r.regnor.studnamec.classnamer.parentr.address from registration r join class c on r.classid=c.classid where r.date between 01/04/2011 and 20/04/2010

Crish · Answer

Select regidstudnameregno classname dobsexparenthousenoplace1place2cityphonomobnoofficeoffplace1offplace2offcityoffphooffmobfaxnationalty busno from registration r inner join class c on r.classid = c.classid inner join bus b on r.busid = b.busid where r.Studname = @StudName -- @studname is the parameter

Ankit Nandekar · Answer

i wan to know what u r inserting in fees field which is in class table.

Shyja Abraham · Answer

fee table contains the details of paid students.

Ankit Nandekar · Answer

can u plz tell me what fees field doing in class table it is showing paid fee or it is a feeid?