Hi guys I need to join my 3 tables
I need to display the data from classlist, account, and student table from a specific class identified by the claID.
For Example:
If I want to display all students coming from class 77, their data from the three table will be joined even if the classlist doesnt match any record on the account and student table.
I need your help ASAP. Thanks in advanced
classList
cllID claID accID
77ses-jap 77 [->] ses-jap [->]
77ses-1-2 77 [->] ses-1-2 [->]
79ses-jap 79 [->] ses-jap [->]
account
accID accFName accLName accMidName accEAdd
ses-admin Jdfafypfe Tdf Gfads
ses-stu Jap Jap Jap djflaj
student
stuID accID stuCourse stuYearLevel stuSection
12345 ses-12345 [->] BSIT 1 dfadsfd
stu ses-stu [->] BSIT 1 a
1 ses-1 [->] BSIT 1 A