Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
senpark15
Starting Member
4 Posts |
 Posted - 2008-09-13 : 00:23:28
|
| hii am having a problem in how to select the student details who have not paid the fees in a particular class.in the feestype table, it has feesid,feestype,term,academicyearand in the table student_fees_paid_details columns are academic year, schoolid,addlissionid,classid.isnewstudent,feesid,feesamount,paymentdateand in the table student payment has academic year,schoolid,admissionid,classid,sectionid,totalamount,reduction, dateand in the table admissiondetails has schoolid,classid,sectionid,admissionno,admissiondate |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-13 : 02:02:45
|
use LEFT JOIN from your admissiondetails table to the student_fees_paid_details table
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-13 : 13:35:40
|
| or use NOT EXISTS / NOT IN |
|
|
|
|
|
|
|
|
fess pending details for students