Page 1 of 1

query help

Posted: Wed Oct 26, 2005 8:47 am
by gurjit
hi all,

my tables are as follows:

tbl_family(familyid)

tbl_student(stuid,frn_familyid,stu_dob,stu_payment)

what i need to do is seperate all the students so that they are put into categories, depending on what there payment type and sibling status is e.g.

Full Paying (Have no siblings and stu_payment is full)
Joe Bloggs
Sandra King

Half Paying (Have no siblings and stu_payment is half)
Amy Grant
Sophie Knight

0 (has 1 younger student)
Tom Cruise

02 (has 2 younger students)
John Smith

03 (has 3 younger students)
Gary Newton

Y (Youngest students of oldest siblings)
Nick Cruise
Frank Smith
Claire Smith
Louise Newton
Laura Newton
Harry Newton



My question is how can i get a query like this from my tables using ("stu_payment" and "stu_dob") ?????

Posted: Wed Oct 26, 2005 9:16 am
by John Cartwright
Moved to Databases.