HI all,
I have three tables
1. Organisation table
2. Class table
2. Student Table
Columns in organisation table are
Id, orgname, orgAddress
Columns in class table are
Id, Orgid,Classname
Note(Id column of orgtable is fk for Orgid in class table)
Columns in student table are
Id,ClassId,StudentName,Address,PhoneNo
Note(Id column of class table is fk for ClassId in student table)
So my requirement is i need complete organisation details along with student count for each organisation
Output:
Slno, orgname, orgAddress, student count
1 pvrInstitute Banglore 30
2 nskInstitute naagpur 50
What I have tried:
HI all,
I have three tables
1. Organisation table
2. Class table
2. Student Table
Columns in organisation table are
Id, orgname, orgAddress
Columns in class table are
Id, Orgid,Classname
Note(Id column of orgtable is fk for Orgid in class table)
Columns in student table are
Id,ClassId,StudentName,Address,PhoneNo
Note(Id column of class table is fk for ClassId in student table)
So my requirement is i need complete organisation details along with student count for each organisation
Output:
Slno, orgname, orgAddress, student count
1 pvrInstitute Banglore 30
2 nskInstitute naagpur 50