Can u join 3table in the same time?

Answer 1

Yes, it's possible

Answer 2

Just do what you need by creating a new view and play around with the view designer

Answer 3

It could be simple and may be a little tricky for example, let say you have 3 students table broken down to ease relationship thus;
tblstudents (studentID, full_name, dob, address, phone)
tblclass_registrations (studentID, session, semester, level)
tblassessments (studentID, subject, ca1, ca2, exams, total, grade, remark)
Supposed from the tables above
You want produce a result by displaying Student’s Name, Subjects and their respective grades, you will need to joint all the 3 tables thus
SQL STATMET ++++++++++++++++++++++++++++++++++++++++++++++++
SELECT tblstudents.full_name, tblclass_registrations.session, tblclass_registrations.level, tblclass_registrations.semester, tblassessments.ca1, tblassessments.ca2, tblassessments.exams, tblassessments.exams, tblassessments.total, tblassessments.grade,
FROM
blstudents, tblclass_registrations, tblassessments
WHERE tblstudents.studentID = tblclass_registrations.studentID
AND tbl tblstudents.studentID = tblassessments
GROUP BY tblassessment.subjects
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
END OF STATEMENT

I hoped it is informative

Answer 4

thanks Guy's