Student_ID Student_Name Roll_No Class_Name Current_Session Current_Term 0001 AAAA 1 1A 2018 1st 0002 BBBB 2 1A 2018 1st 0003 CCCC 3 1A 2018 1st 0004 DDDD 4 1A 2018 1st 0005 EEEE 5 1A 2018 1st 0006 FFFF 1 1B 2018 1st 0007 GGGG 2 1B 2018 1st
Enroll_ID Student_ID Class_Name Subject Session Term CA1 1 0001 1A ENG 2018 1st 7 2 0002 1A MTH 2018 1st 6 3 0001 1A ENG 2018 2nd 9
Student_ID CA1 0001 7 0002 0003 0004 0005
I hope I'm clear enough.
"SELECT tbl_students.Student_ID AS Student_ID , tbl_students.Student_Name AS Student_Name , tbl_students.Class_Name AS Class_Name , tbl_students.Roll_No AS Roll_No , tbl_subjects_enrollment.Enroll_ID AS Enroll_ID , tbl_subjects_enrollment.Subject_Code AS Subject_Code , tbl_subjects_enrollment.CA1 FROM tbl_students LEFT JOIN tbl_subjects_enrollment ON tbl_students.Student_ID=tbl_subjects_enrollment.Student_ID WHERE tbl_students.Default_Session = ? AND tbl_students.Default_Term = ? AND tbl_students.Class_Name = ? AND tbl_subjects_enrollment.Subject_Code = ? AND tbl_students.Status = 1 ORDER BY tbl_students.Roll_No ASC LIMIT ? "
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.Get Access
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Connect with Certified Experts to gain insight and support on specific technology challenges including: